Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aligning decimal point in a column of figures in Excel | Excel Worksheet Functions | |||
Decimal point | New Users to Excel | |||
Cut &paste clears numbers after the decimal point | Excel Worksheet Functions | |||
how can i move the starting point for the numbers numbers down. | Setting up and Configuration of Excel | |||
Why am I getting .+ when I hit the decimal point? | Excel Discussion (Misc queries) |