Showing zero balances

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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

Access Running Balance in Access 1
Simple VB for Excel Question 3
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Excel 2007 adding a column of negative and positive number 2
Can I suppress printing a line if a value = 0? 3
Hiding values in cells 1
Look Up Help Needed 3
Segregate Outstanding Payment 1

Back
Top