format existing numbers in excel?
 

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

Can you just divide them all by 100?

"Robin" wrote:

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

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 SpecialDivideOKEsc.

Clear the cell with 100.


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 17:19:03 -0800, "Robin"
wrote:

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

On Wed, 2 Mar 2005 17:19:03 -0800, "Robin"
wrote:

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

I am unsure what you mean by this: Select your numbers and Paste
SpecialDivideOKEsc?

"Gord Dibben" wrote:

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 SpecialDivideOKEsc.

Clear the cell with 100.


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 17:19:03 -0800, "Robin"
wrote:

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

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

"Gord Dibben" wrote:

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 SpecialDivideOKEsc.

Clear the cell with 100.


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 17:19:03 -0800, "Robin"
wrote:

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

Good stuff!

Thanks for the feedback.

Gord

On Wed, 2 Mar 2005 17:45:02 -0800, "Robin"
wrote:

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

"Gord Dibben" wrote:

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 SpecialDivideOKEsc.

Clear the cell with 100.


Gord Dibben Excel MVP

On Wed, 2 Mar 2005 17:19:03 -0800, "Robin"
wrote:

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