If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 convert cm to inches
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## convert cm to inches

#1
January 22nd 05, 04:59 PM
 VPH external usenet poster Posts: n/a
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
January 22nd 05, 05:41 PM
 Biff external usenet poster Posts: n/a

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

#3
January 22nd 05, 06:42 PM
 Bernard Liengme external usenet poster Posts: n/a

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?
>
>
> 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
January 22nd 05, 06:59 PM
 Gord Dibben external usenet poster Posts: n/a

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 > 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 Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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 10:24 PM Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM Convert Time...!convert tenths of a second Pape Excel Discussion (Misc queries) 2 December 16th 04 10:17 AM Is there a formula to convert numbers to written text in Excel? LZC Excel Worksheet Functions 3 November 27th 04 08:10 PM Converting inches to feet & inches. svech61 Excel Worksheet Functions 2 November 27th 04 04:23 AM

All times are GMT +1. The time now is 02:24 AM.