Currency & Accounting Format Mixture
 

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!

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!

Currency & Accounting Format Mixture
 

Yes this can be done. Right click and format cells, in the number tab, go to
custom and use the following:
_($* #,##0.00_)

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!

--
Message posted via http://www.officekb.com