Move A Decimal Point

[sabegirl]

In cell I2 is I have 0.6617

How do I convert to 66.17

Thanks for your help. Pegg

 

[Damon Longworth]

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

 

[samprince]

you can't convert to another value.

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

 

[Guest]

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