Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Showing zero balances
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 |
#2
|
|||
|
|||
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 "Ed" wrote in message ... 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 |
#3
|
|||
|
|||
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) "Ed" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
formula in cell not showing result | Excel Worksheet Functions | |||
Need Budget Template for Bills, expenses, credit card balances wh. | New Users to Excel | |||
Bar showing value for missing data | Charts and Charting in Excel | |||
How to link endings balances to beginning balances on different sh | Excel Worksheet Functions |