Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert cm to inches
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? |
#2
|
|||
|
|||
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 ToolsAdd-ins Check Analysis ToolPak OR 1 centimeter = 0.393700787 in =A2*.393700787 Biff -----Original Message----- 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? . |
#3
|
|||
|
|||
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 "Biff" wrote in message ... 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 ToolsAdd-ins Check Analysis ToolPak OR 1 centimeter = 0.393700787 in =A2*.393700787 Biff -----Original Message----- 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? . |
#4
|
|||
|
|||
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 ToolsAdd-ins and checkmark the ATP. Gord Dibben Excel MVP On Sat, 22 Jan 2005 08:59:01 -0800, VPH wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Converting inches to feet & inches. | Excel Worksheet Functions |