# convert cm to inches

=?Utf-8?B?VlBI?=
Guest
Posts: n/a

 22nd Jan 2005
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?

Biff
Guest
Posts: n/a

 22nd Jan 2005
Hi!

From Excel help on convert:

"If this function is not available, and returns the #NAME?

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?
>.
>

Bernard Liengme
Guest
Posts: n/a

 22nd Jan 2005
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" <(E-Mail Removed)> wrote in message
news:18a701c500a9\$902983c0\$(E-Mail Removed)...
> Hi!
>
> From Excel help on convert:
>
> "If this function is not available, and returns the #NAME?
>
>
> 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?
>>.
>>

Gord Dibben
Guest
Posts: n/a

 22nd Jan 2005
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

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

Gord Dibben Excel MVP

On Sat, 22 Jan 2005 08:59:01 -0800, VPH <(E-Mail Removed)> 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?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Jason Stripling Microsoft Excel Misc 4 10th Oct 2012 04:49 PM Mark Main Microsoft Excel Worksheet Functions 9 26th Nov 2008 09:50 PM airutah Microsoft Access Reports 2 27th Feb 2008 07:08 PM =?Utf-8?B?Y2FibGUgZ3V5?= Microsoft Excel Misc 1 20th Jun 2005 07:29 PM =?Utf-8?B?Sm9obiBCYXRlcw==?= Microsoft Excel Worksheet Functions 1 23rd Sep 2004 08:24 PM

Features