Hiding Zero Values on Excel Spreadsheet 1

[jhetfield]

I've created a purchase order form in excel. It has 20 rows (each row is for each different item ordered.) Each row has a formula for TOTAL, which is a result of values in two other columns. Then at the bottom of the 20 rows there is another TOTAL which is the sum of the the row totals. Because this is a form, it will be used for varying amounts of products (rows). Because I want the sum of row totals at the bottom, the rows that aren't being used show a value of $0.00 I'd like to format those cells so that only values other than $0.00 are shown.

Thanks, Jason

 

[SkipVought]

Hi,

Select a Numeric Format that represents a ZERO value as - .. Format/Cells...

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[SkipVought]

BTW, its the Accounting Category with NONE as the prefix

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244