Currency & Accounting Format Mixture
Custom format the cells to . Isnt that the default currency format..
$#,##0.00
If this post helps click Yes
---------------
Jacob Skaria
"pmsimp" wrote:
We have a 2003 spreadsheet where we would like "$" to remain on the left side
of the cell, but if the cell value is "0.00" - we would like that displayed,
instead of just a dash. Can this be done?
Thanks!
|