Number Formatting Dollars to Cents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list with a column containing what are supposed to be dollar amounts but for whatever reason came to us with numbers like this:
+000000040
+000000560
This number is supposed to be 40 cents. If I take out the +sign, Excel automatically changes it to 40, or $40. How can I move the decimal so that it becomes $.40? And in the second example, $5.60 rather than $560.?
All help is greatly appreciated!
Vickie
 
Hi Vickie!

Your numbers appear to be text.

Put 100 in an empty cell
Copy
Select the text numbers
Edit > Paste special > Divide > OK
Format as currency

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I have a list with a column containing what are supposed to be dollar amounts but for whatever reason came to us with numbers like this:
+000000040
+000000560
This number is supposed to be 40 cents. If I take out the +sign, Excel automatically changes it to 40, or $40. How can I move the decimal so that it becomes $.40? And in the second example, $5.60 rather than $560.?
All help is greatly appreciated!
Vickie
Click to expand...

In some blank cell put the number 100.

Select that cell and Copy.

Select your column with the +00000040, etc.

Paste Special/Divide

Format as Currency.


--ron
 
Vickie

Enter 100 in a cell. Copy and select your range to change.

Paste Special>Divide>OK>Esc

Clear the cell with the 100.

Gord Dibben Excel MVP
 
Back
Top