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 am entering a number in a cell (not a formula) the number is $4,508.46.
I've set it up that I want to use the accounting mode with two decimal
places. When I enter the number it reads $450,846.00. If I don't put cents it
comes out to $4,508.00. What can I do so that I don't have to enter it
manually? (I have a lot of numbers to put in)

Thank you