can somebody tell me how many meters are in 1.2 miles?
can somebody tell me how many meters are in 1.2 miles?
Multiply miles by 1609.344 to convert to metres (or meters for those the
other side of the pond!!)
--
Regards
Roger Govier
"crlathem" <[email protected]> wrote in message
news:[email protected]...
> can somebody tell me how many meters are in 1.2 miles?
You can check out the Convert() function in the Help files.
=CONVERT(1.2,"mi","m")
Ans. = 1931.213
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"crlathem" <[email protected]> wrote in message
news:[email protected]...
> can somebody tell me how many meters are in 1.2 miles?
=convert(A20,"mi","m")
where A20 holds the value in miles
--
HTH
RP
(remove nothere from the email address if mailing direct)
"crlathem" <[email protected]> wrote in message
news:[email protected]...
> can somebody tell me how many meters are in 1.2 miles?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks