Hide Zeros

You can either hide zeros by unchecking the "Zero values" checkbox (Tools, Options, View) or enter General;General; as a custom format in the Format Cell dialog box. (Don't forget the second semicolon). Another possible custom format is [Black][<>0]General.



© Copyright andrewsexceltips.net. All Rights Reserved.