I have a formula in a cell which is calculating from several cells.
When the value comes out at zero, I want a dash to display, not zeros.
I have read the tip on this subject, and tried it, but it does not work!
:( I have used the following syntax:

#,##0.00;[Red](#,##0.00);- ;

This should do the following:

1. When the result is positive, the display should have two decimal
places with a thousands separator.
2. When the results is negative, the display should have all the
above, but be red and have brackets around it.
3. When the result is zero, only a dash should be visible.

When my formula has a zero result, it shows "0.00" or "(0.00)"! Can
anybody tell me why??

Jonathan


--
Jonibenj
------------------------------------------------------------------------
Jonibenj's Profile: http://www.excelforum.com/member.php...o&userid=17048
View this thread: http://www.excelforum.com/showthread...hreadid=465821