Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have formatted cells with the accounting format with no symbol. Two cells
that compute to zero show differently. One shows 0.00 and the other shows a "-" dash. I have rechecked all of the cells that are included in the formula for each and I cannot find any inconsistencies; all are formatted the same. I realize that this seems petty but for the life of me I cannot determine why the same formatting shows two different designations for zero. I prefer the "-" dash. Can anyone suggest what I can look at to try and resolve this? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Some formula results will not show up in the cell | Excel Worksheet Functions | |||
Custom Cell Format Will Not Save Correctly | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) |