How do I use Excel to convert feet to kilometers?
in [Functions]
|
From: CedarHillMatt on 22 Feb 2010 16:11 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?
From: FSt1 on 22 Feb 2010 16:22 hi do you have the analysis tool back installed and does your formula look somthing like this..... =CONVERT(A2,"m","ft") where A2 is the number to convert. the above converts meters to feet and works perfectly on my pc. regards FSt1 "CedarHillMatt" wrote: > 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?
From: macropod on 22 Feb 2010 16:22 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" <CedarHillMatt(a)discussions.microsoft.com> wrote in message news:0F1D2A9D-24D7-4F30-9315-A70CAACE07EF(a)microsoft.com... > 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?
From: FSt1 on 22 Feb 2010 17:29 hi that should be analysis tool PACK not back. sorry. my prepost proof reader is off today. Regards FSt1 "FSt1" wrote: > hi > do you have the analysis tool back installed and does your formula look > somthing like this..... > =CONVERT(A2,"m","ft") where A2 is the number to convert. > > the above converts meters to feet and works perfectly on my pc. > > regards > FSt1 > > "CedarHillMatt" wrote: > > > 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?
|
Pages: 1 Prev: changing a calculation in a pivot table Next: Counting NON-Blank fields |