I don't know why two worksheets in the same workbook would display the same
number differently with the same number format. In fact I'm a little
dubious all those conditions can be true.

But anyway, with your number format a value that is not _exactly_ zero will
display as "0.00". Enter .000001 in a cell with the accounting format to
see this. It's not usually for formulas to return near zero when the real
answer is exactly zero because of how binary processors deal with base 10
numbers. You might try setting "Precision as Displayed" on under Tools,
Options, Calculation. This mean that a cell will actually have the value it
appears to have. So your .00001 will in fact be zero with the accounting
format assigned to it. I swear by this setting but you have to be aware
that if a cell has say .75 typed in it but is formatted to show no decimal
places (so it appears as "1" then this setting will actually change the .75
to 1.

--
Jim
"Lost4Now" wrote in
message ...

Two worksheets in same workbook.

Column E formatted - Format Cells - Accounting - Decimal Places 2 -
Symbol $

In one sheet the cell displays "$ - " while the other sheet
displays "$ (0.00)" whenever the cells have a zero balance.

The two sheets both use a formula =E469+C470-D470 - different rows but
same columns.

The sheet displaying "$ (1.00)" has numerous zero, and negative,
values.
The sheet displaying "$ - " has zero values, however no
negative values.

To test the second sheet, I placed some negative values in the second
sheet and "$ (1.00)" was displayed, however, a zero value still
displayed "$ - "

The cells are displayed in one column on a third sheet with a number of
cells from other sheets, which do not have zero or negative balances -
the "glaring" difference in the cell with "$ (0.00)" has annoyed me
for years, finally thought I would ask around. Would love to be able
to replace "$ (0.00)" with "$ - ".

The column just doesn't line up as orderly as I would like!

Dean Thomas


--
Lost4Now
------------------------------------------------------------------------
Lost4Now's Profile:
http://www.excelforum.com/member.php...o&userid=29345
View this thread: http://www.excelforum.com/showthread...hreadid=508457