format existing numbers in excel?

[Guest]

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??

 

[Guest]

Can you just divide them all by 100?

 

[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

 

[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??

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

 

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

Good stuff!

Thanks for the feedback.

Gord

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