| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Centimeters to inches formula!
Is there a formula for converting centimeters into inches? I am really new at excel so I do not know ? Any help would be appreciated. Thank you. -- rageon75 ------------------------------------------------------------------------ rageon75's Profile: http://www.excelforum.com/member.php...o&userid=31862 View this thread: http://www.excelforum.com/showthread...hreadid=570955 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Centimeters to inches formula!
There are 2.54 cm per inch -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=570955 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Centimeters to inches formula!
Can you give me an example of the formula. I really new at excel. Thank you. -- rageon75 ------------------------------------------------------------------------ rageon75's Profile: http://www.excelforum.com/member.php...o&userid=31862 View this thread: http://www.excelforum.com/showthread...hreadid=570955 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Centimeters to inches formula!
Simple arithmetic........
In A1 you have 254 In B1 enter =A1/2.54 Will return 100 inches. Gord Dibben MS Excel MVP On Fri, 11 Aug 2006 19:23:16 -0400, rageon75 wrote: Is there a formula for converting centimeters into inches? I am really new at excel so I do not know ? Any help would be appreciated. Thank you. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Centimeters to inches formula!
Suppose you have 10 cm and you want to convert this to inches. Enter 10
into cell A1 and in B1 enter this formula: =A1 / 2.54 If, then, you want to convert 12 cm, just enter 12 into cell A1 and you will have your answer in B1. Hope this helps. Pete rageon75 wrote: Can you give me an example of the formula. I really new at excel. Thank you. -- rageon75 ------------------------------------------------------------------------ rageon75's Profile: http://www.excelforum.com/member.php...o&userid=31862 View this thread: http://www.excelforum.com/showthread...hreadid=570955 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Centimeters to inches formula!
Thank you so much. I really appreciate it! -- rageon75 ------------------------------------------------------------------------ rageon75's Profile: http://www.excelforum.com/member.php...o&userid=31862 View this thread: http://www.excelforum.com/showthread...hreadid=570955 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Centimeters to inches formula!
=CONVERT(A1,"cm","in")
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "rageon75" wrote in message ... Is there a formula for converting centimeters into inches? I am really new at excel so I do not know ? Any help would be appreciated. Thank you. -- rageon75 ------------------------------------------------------------------------ rageon75's Profile: http://www.excelforum.com/member.php...o&userid=31862 View this thread: http://www.excelforum.com/showthread...hreadid=570955 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| Change measurements from inches to centimeters in EXCEL 2002? | Excel Discussion (Misc queries) | |||
| How do I convert an entire spread sheet form inches to centimeters | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Convert my entire spreadsheet from inches to centimeters | Excel Discussion (Misc queries) | |||
Linear Mode
