Excel Functions&Formulas >> convert cm to inches

by VlBI » Sun, 23 Jan 2005 00:59:01 GMT

Although the convert function is listed in excel 2002 help it is not
available from the insert formula command and it does't work in excel 2002.
s there a way to get it to work?
=CONVERT(A2,"cm","in") Returns NAME?

Excel Functions&Formulas >> convert cm to inches

by Biff » Sun, 23 Jan 2005 01:41:11 GMT


From Excel help on convert:

"If this function is not available, and returns the #NAME?
error, install and load the Analysis ToolPak add-in."

Goto Tools>Add-ins

Check Analysis ToolPak


1 centimeter = 0.393700787 in



help it is not
work in excel 2002.

Excel Functions&Formulas >> convert cm to inches

by Bernard Liengme » Sun, 23 Jan 2005 02:42:26 GMT

Since WWII the inch (Imperial and US) has been defined as 2.54 cm EXACTLY.
This means the US has been sort-of-metric for 60 years!
So a more accurate conversion is 0.393700787401575

I would use (1/2.54) as the conversion factor.

Bernard V Liengme
remove caps from email

Excel Functions&Formulas >> convert cm to inches

by Gord Dibben » Sun, 23 Jan 2005 02:59:29 GMT


If you read the 2002 Help on CONVERT carefully you will see this........

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

To load the Analysis Toolpak go to Tools>Add-ins and checkmark the ATP.

Gord Dibben Excel MVP

Similar Threads

1. cm/inches - Excel

2. How do I change the autoshape size from inches to cm

I do drawings on Excell. I work in Metric and not Imperial measurements. In 
the Format autoshape under under size the sizes of an shape are in Inches and 
I want to change it to Centimeters. How do I do that?

3. cm to inch conversion - Excel

4. Excel displaying inches not cm

Having a problem with Excel recently (last week or so) whereby the "format 
Picture" option is displaying the measurements in inches, despite the OS 
Regional Setting of Metric. 

1) I have switched the regional setting from Metric to US, then back to 
Metric, which fixes the problem, but it then reverts to inches when I reopen 
2) Only affecting Excel, not Word etc.
3) Only affecting the Format Picture option, the margins and page sizes are 
still displaying in cm/mm
4) Excel 2003, on WinXP

Any help would be greatly appreciated.

5. change margens messure from inches to cm.

6. Change cm to inches in Format Picture size

In excel I want to change the unit of measure cm to inches. It's in the size 
tab of the format picture 

7. Change default measurements from cm to inches

8. Formula converts value into Feet, Inches & Fraction of an Inch

If you've ever wanted to display Feet and Inches with Fractions of an
Inch, then this formula is for you.  For example, this will change a
value of 15.125 to be 1' 3-1/8"

Type a number in A1, and paste this formula into B1:

=IF(A1<0,"("," ") & IF(TRUNC(ABS(ROUND(A1*16,0)/16)/
12,0)<1,"",TRUNC(ABS(ROUND(A1*16,0)/16)/12,0) & "'" & IF(MOD(ABS(A1),
12)=0, ""," ")) & IF(TRUNC(ABS(ROUND(A1*16,0)/
TRUNC(ABS(ROUND(A1*16,0)/16)-12*TRUNC(ABS(ROUND(A1*16,0)/16)/12,0)) &
IF(MOD(ABS(A1),1)=0,"","-"),"") & IF(MOD(A1,1)=0,"",MOD(ABS(A1),1)*16/
GCD(ROUND(ABS(A1)*16,0),16) & "/" & 16/ABS(GCD(ROUND(ABS(A1)*16,0),
16))) & IF(MOD(ABS(A1),12)=0,"","""") & IF(A1<0,")"," ")

It will reformat the number into Feet, Inches, and Fractions of
1/16".  It will round the number to the nearest sixteenth inch.
Notice that it also places parentheses () around negative numbers.

If you want something rather than 16th of an inch, simply do a mass
change of 16 to 8ths or whatever you want.  Be sure to leave the 12's
alone, they are for Feet.

Hope that it's useful to someone out there.