PC Review


Reply
Thread Tools Rate Thread

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?
 
Reply With Quote
 
 
 
 
Biff
Guest
Posts: n/a
 
      22nd Jan 2005
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

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

 
Reply With Quote
 
 
 
 
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?
> 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
>
>>-----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?
>>.
>>



 
Reply With Quote
 
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
load the Analysis ToolPak add-in.

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?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert decimal inches into feet and inches Jason Stripling Microsoft Excel Misc 4 10th Oct 2012 04:49 PM
Convert inches & display as Feet Inches and Fractions -- BUG FREE Mark Main Microsoft Excel Worksheet Functions 9 26th Nov 2008 09:50 PM
convert inches to feet, inches airutah Microsoft Access Reports 2 27th Feb 2008 07:08 PM
is there a macro that will convert from inches to feet and inches =?Utf-8?B?Y2FibGUgZ3V5?= Microsoft Excel Misc 1 20th Jun 2005 07:29 PM
how to convert feet-inches-fractions to feet (or inches) in Excel =?Utf-8?B?Sm9obiBCYXRlcw==?= Microsoft Excel Worksheet Functions 1 23rd Sep 2004 08:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:00 PM.