Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
VPH
 
Posts: n/a
Default 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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 11:24 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 10:25 PM
Convert Time...!convert tenths of a second Pape Excel Discussion (Misc queries) 2 December 16th 04 11:17 AM
Is there a formula to convert numbers to written text in Excel? LZC Excel Worksheet Functions 3 November 27th 04 09:10 PM
Converting inches to feet & inches. svech61 Excel Worksheet Functions 2 November 27th 04 05:23 AM


All times are GMT +1. The time now is 11:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"