Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formatting
I have a strange scenario. I have 2 different worksheets in my workbook. I
have similiar data and formulas in both (in fact I created the second one as a copy/paste of the first one). On my first sheet, I have some cells with a sum formula, and I have the cell formatted as "General" and when the result is zero, it does not display anything in the cell. On the other sheet, it has the same formula and number formatting, but it displays the zeros. When I got into the number formatting for each cell, the one that displays nothing for zero, shows that in the "Sameple" in the number formatting dialog and the other shows the zero in the dialog. I would like to have the behavior of showing nothing for zero. Does anyone know how I actually got that to happen? Thanks, Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Formatting
One guess is that its the sheet specific setting via clicking (in xl03):
Tools Options View tab Uncheck "Zero values" OK -- Max Singapore http://savefile.com/projects/236895 Downloads:16,400 Files:356 Subscribers:53 xdemechanik --- "Steve Haack" wrote: I have a strange scenario. I have 2 different worksheets in my workbook. I have similiar data and formulas in both (in fact I created the second one as a copy/paste of the first one). On my first sheet, I have some cells with a sum formula, and I have the cell formatted as "General" and when the result is zero, it does not display anything in the cell. On the other sheet, it has the same formula and number formatting, but it displays the zeros. When I got into the number formatting for each cell, the one that displays nothing for zero, shows that in the "Sameple" in the number formatting dialog and the other shows the zero in the dialog. I would like to have the behavior of showing nothing for zero. Does anyone know how I actually got that to happen? Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number formatting | Excel Discussion (Misc queries) | |||
number formatting help | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Number Formatting | Excel Discussion (Misc queries) | |||
number formatting | Excel Discussion (Misc queries) |