Moving Decimal Point

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TonyCC - 03 Mar 2008 22:39 GMT

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.

Reply to this Message

Bernard Liengme - 03 Mar 2008 22:52 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>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
[quoted text clipped - 6 lines]
> by
> .01, but I'm wondering if there is a better way to do it.

Reply to this Message

TonyCC - 03 Mar 2008 23:06 GMT

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

> Did you use this method:
> type 0.01 in an otherwise blank cell
[quoted text clipped - 15 lines]
> > by
> > .01, but I'm wondering if there is a better way to do it.

Reply to this Message

Rate this thread: