T
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.
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.