converting feet to yards

K

Kevin B

Insert a blank column to the right of the column you want to convert and
enter this formula.

=CONVERT(A1,"ft","yd")

Changing the starting cell of A1 to your starting cell. Then copy down the
column.

If you look up CONVERT in help you'll get a list of all the conversions you
can do with this very useful function.
 
P

Paul B

Christina, put 3 in an unused cell, copy that cell, select the data you want
to convert, edit, paste special, divide, ok
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

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

Football stats 9
Scaling numbers for display 0
Largest number in column 4
Converting feet to yards within a column 1
Averaging feet and inches (not decimal feet) 4
adding feet and inches 3
Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56) 6
FORMAT FOR FEET AN DINCHES 2

Top