Moving Decimal Point

[TonyCC]

I have a bunch of currency number data that was imported from a text file
that has no decimal point. So, for example, 12.48 shows up in Excel as 1248.
Of course changing the cell format in Excel now only adds a decimal point
and zeros to the end of the number so it shows up as 1248.00. Is there a way
to format the cell and move the decimal point to the left after the number
has been entered? As a workaround I multiplied everything in the column by
..01, but I'm wondering if there is a better way to do it.

 

[Bernard Liengme]

Did you use this method:
type 0.01 in an otherwise blank cell
copy that cell
select the range to be fixed
use Edit | Paste Special and specify multiply

That's the only way I can think of without using another column with formula
=A1/100
best wishes

 

[TonyCC]

I did use multiple columns. Thanks for the tip with the Paste Special.
Works great!