Thread: Number Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aarmpa aarmpa is offline
external usenet poster
 
Posts: 2
Default Number Format

I want to format some cells in the accounting mode, I used 2 decimal places.
One of the numbers is $4,508.46. If I use that format I get $450,846.00. What
can I do so that I do not have to do it manually?

Thank you in advance