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