Try this:
Put 0.01 in a blank cell
Copy that cell
Select the range of number you want to move the decimal point on.
EditPaste Special
Check: Multiply and Values
Click [OK]

(If that doesn't do what you want....EditUndo)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Roberta" wrote:

Earlier in the year we rec'd a spreadsheet for prices. The format was 2.30,
1.05 etc. to make it simpler, someone change it to 230, 105 and the
decimals was assumed after the 1st digit. Now the customer wants it back to
2.30 vs 230 but the format has been permanently changed. Is there any hope
here of changing it back?