Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells to make zeros not appear,or be invisible on screen &p
Hi,
Does anyone know how to format a cell so that it looks empty when a zero is put in? I am using the custom number format of #,##0;(#,##0) so that I can put company accounts onto a sheet, where negative values appear in brackets. I want to extend the format so that zeros appear as blanks (or rather, they do not appear). When turnover is zero, so far, if I leave the cell blank, the average function does not take it into consideration. On the other hand, I do not want any zeros to "appear" on my page or my hard copies as there are lots of them. Hard enough as it is, finally, is there also a way to edit my format to make zeros appear as any other character, for example a hyphen "-" ? Thank you for your help. Rajen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make hidden sheet invisible | New Users to Excel | |||
How do I keep leading zeros and format my cells as text? | Excel Discussion (Misc queries) | |||
format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
how do i format cells with preceeding zeros & minus sign | Excel Worksheet Functions | |||
color filled cell invisible on work screen | Excel Worksheet Functions |