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