Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I formated all numbers in my table as Accounting. When the value is zero (0)
the table displays a - in the cell. But some of the cells display a 0.00 or a (0.00). I check the formatting and they are all in Accounting. I even copy the formatting from one cell to another, but they do not change the way excel displays the number. What is happening? The numbers are part of a series of formulas, but with the exception of a few cells, they all display the zero result as -, which is what I want. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |