Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert 1.2 miles to meters
can somebody tell me how many meters are in 1.2 miles?
|
#2
|
|||
|
|||
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" wrote in message ... can somebody tell me how many meters are in 1.2 miles? |
#3
|
|||
|
|||
Multiply miles by 1609.344 to convert to metres (or meters for those the other side of the pond!!) -- Regards Roger Govier "crlathem" wrote in message ... can somebody tell me how many meters are in 1.2 miles? |
#4
|
|||
|
|||
=convert(A20,"mi","m")
where A20 holds the value in miles -- HTH RP (remove nothere from the email address if mailing direct) "crlathem" wrote in message ... can somebody tell me how many meters are in 1.2 miles? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
convert character to value at relative cell | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Subtracting based on number of miles | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |