Thread: Display 0.00 instead of -
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default Display 0.00 instead of -
hi
your format may be set to accounting. reformat to general, number or currency.

Regards
FSt1

"Mike" wrote:

How do I get Excel to display 0.00 instead of a -.
Reply With QuoteReply With Quote