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

"crlathem" wrote:

can somebody tell me how many meters are in 1.2 miles?