How do I use Excel to convert feet to kilometers?

C

CedarHillMatt

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

FSt1

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
 
M

macropod

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
 
F

FSt1

hi
that should be analysis tool PACK not back.
sorry.
my prepost proof reader is off today.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003, how to convert gallons to cubic feet? 6
convert meters to feet/inches 21
How do I convert shading to highlighting for specific colors 8
How do I convert decimal to feet and inches 5
I type in a number in a cell but it wont convert to currency help 2
Excel - Wich Function should I use? 1
How do I install Microsoft Equation 3.0 back to Office 365? 0
how to convert feet-inches-fractions to feet (or inches) in Excel 1

Top