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