Move A Decimal Point
 

In cell I2 is I have 0.6617

How do I convert to 66.17

Thanks for your help. Peggy


--
sabegirl
------------------------------------------------------------------------
sabegirl's Profile: http://www.excelforum.com/member.php...o&userid=33982
View this thread: http://www.excelforum.com/showthread...hreadid=572269

Move A Decimal Point
 

Multiply by 100.

--
Damon Longworth

2006 West Coast Excel / Access User Conference
October 25-27th, 2006
Marina del Rey Hotel
Marina del Rey, California USA
http://www.exceluserconference.com/WCEUC.html

"sabegirl" wrote in
message ...

In cell I2 is I have 0.6617

How do I convert to 66.17

Thanks for your help. Peggy


--
sabegirl
------------------------------------------------------------------------
sabegirl's Profile:
http://www.excelforum.com/member.php...o&userid=33982
View this thread: http://www.excelforum.com/showthread...hreadid=572269

Move A Decimal Point
 

you can't convert to another value.

Best bet insert another row alongside and in [J2] type =I2*100


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=572269

Move A Decimal Point
 

Put 100 in a blank cell, copy this cell
Right click on cell I2, choose "Paste Special"
Select "Multiply"
Select OK

--
Regards,
Dave


"sabegirl" wrote:


In cell I2 is I have 0.6617

How do I convert to 66.17

Thanks for your help. Peggy


--
sabegirl
------------------------------------------------------------------------
sabegirl's Profile: http://www.excelforum.com/member.php...o&userid=33982
View this thread: http://www.excelforum.com/showthread...hreadid=572269