View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 293
Default How do I use Excel to convert feet to kilometers?

Hi CedarHillMatt,

The correct construction of this function for a value in A1 is:
=CONVERT(A1,"ft","km")
Of course, you could do it the old-fashioned way:
=A1*0.0003048

--
Cheers
macropod
[Microsoft MVP - Word]


"CedarHillMatt" wrote in message
...
I'm trying to use Excel 2002 to convert feet to kilometers. When I try to use
the CONVERT worksheet function, "#NAME?" is returned. It does the same thing
no matter what units of measure I try to convert. I copied and pasted the
syntax directly from the Office Help section. Any ideas?