Anyone know off-hand the command to convert a number:

0000000456

to:

4.56

I tried this:
Application.FixedDecimal = True
Application.FixedDecimalPlaces = 2

Which works, but not if you're copying the data from another workbook.

Any ideas?


Garrett (MIS)