Number Format

A

aarmpa

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
 
D

dhstein

You have 2 choices:

1) Enter the number with the decimal point 4508.46

2) Enter the number without the decimal point and when you're done entering
all the numbers - create a formula to divide each number by 100 - then copy
and Paste special values
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number Format 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Assign custom number format to the ribbon 0
Stop XL from changing format? 1
Concatenate & Number Formats 2
Numbers changing between sheets 13
How do I prevent the cell from changing the number I enter? 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Top