In cell I2 is I have 0.6617 How do I convert to 66.17 Thanks for your help. Pegg
S sabegirl Aug 16, 2006 #1 In cell I2 is I have 0.6617 How do I convert to 66.17 Thanks for your help. Pegg
D Damon Longworth Aug 16, 2006 #2 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
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
S samprince Aug 16, 2006 #3 you can't convert to another value. Best bet insert another row alongside and in [J2] type =I2*10
D David Billigmeier Aug 16, 2006 #4 Put 100 in a blank cell, copy this cell Right click on cell I2, choose "Paste Special" Select "Multiply" Select OK
Put 100 in a blank cell, copy this cell Right click on cell I2, choose "Paste Special" Select "Multiply" Select OK
