View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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!