Showing zero balances


G

Guest

Is there a way to show zero balances in some selected cells and at the same
time not show zero balances in the other cells?
Ed
 
Ad

Advertisements

B

Biff

Hi!

Use this custom format to "hide" the zeros you don't want displayed:

0;-0;;@

Just be aware that the zero is still there, it just can't be seen.

Biff
 
Ad

Advertisements

P

Peo Sjoblom

What do you want in those cells not showing zero, blank? If so you can use
custom formatting for those that you don't want to show

$#,##0.00;-$#,##0.00;

using US centric currency and no zeros shown

--
Regards,

Peo Sjoblom

(No private emails please)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables show zero balance 3
show balance 2
Hide rows with zero balances 11
Zeros Not Showing 4
Show Zeros 1
Show zero 2
Pivot Tables - Exclude Rows With Zero Balances 2
Show zero values 4

Top