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?

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?

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?

Hi!

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

OR

1 centimeter = 0.393700787 in

=A2*.393700787

Biff

help it is not

work in excel 2002.

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

www.stfx.ca/people/bliengme

remove caps from email

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

www.stfx.ca/people/bliengme

remove caps from email

VPH

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

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

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 excel 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)/ 16)-12*TRUNC(ABS(ROUND(A1*16,0)/16)/12,0))>=1, 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. Mark