format existing numbers in excel?

R

Robin

I have an existing spreadsheet, and I need to format existing numbers in the
cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I
right click on the cell to format and choose number and 2 decimal places, it
adds zeros (515.00 or 72957.00) Is there ANY way to do this??
 
G

Gord Dibben

Robin

This is not just a formatting issue. You need to actually change the values.

Enter 100 in an empty cell.

Copy that cell.

Select your numbers and Paste Special>Divide>OK>Esc.

Clear the cell with 100.


Gord Dibben Excel MVP
 
R

Ron Rosenfeld

I have an existing spreadsheet, and I need to format existing numbers in the
cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I
right click on the cell to format and choose number and 2 decimal places, it
adds zeros (515.00 or 72957.00) Is there ANY way to do this??
Click to expand...

If I understand you correctly, you want to DIVIDE the existing numbers by 100.

In some blank cell, enter the number 100 and select that cell.
Edit/Copy
Select the existing numbers
Edit/Paste Special Operation Divide


--ron
 
R

Robin

I am unsure what you mean by this: Select your numbers and Paste
Special>Divide>OK>Esc?
 
R

Robin

I figured it out............wow, thanks so much! That will save me lot's of
work....
 
Top