can somebody tell me how many meters are in 1.2 miles?
R Roger Govier Aug 4, 2005 #2 Multiply miles by 1609.344 to convert to metres (or meters for those the other side of the pond!!)
B Bob Phillips Aug 4, 2005 #3 =convert(A20,"mi","m") where A20 holds the value in miles -- HTH RP (remove nothere from the email address if mailing direct)
=convert(A20,"mi","m") where A20 holds the value in miles -- HTH RP (remove nothere from the email address if mailing direct)
A Andrea Jones Aug 4, 2005 #4 If you have the Analysis Toolpak add-in installed you can use the CONVERT function: =CONVERT(1.2,"mi","m") This gives the answer 1931.2128 Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com
If you have the Analysis Toolpak add-in installed you can use the CONVERT function: =CONVERT(1.2,"mi","m") This gives the answer 1931.2128 Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com
