Converting Miles To Metres

tenrec | 22:29 Mon 18th Feb 2013 | ChatterBank

6 Answers

Please can you tell me the formula for converting miles to metres. I want to do it in Excel. So I enter the miles in one column and then in another column it will tell me how many metres. Many thanks for your help.

Whose Shed?

Night Night Song From Mamya♥

Answers

1 to 6 of 6

Best Answer

No best answer has yet been selected by tenrec. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

factor-fiction

1 mile = 1609.344 metres

bibblebub

you could use the CONVERT() function https://office.microsoft.com/en-us/excel-help/convert-measurements-HP003056127.aspx

factor-fiction

If it's for converting distance run into metres I'd just use 1 mile = 1.6 meters, or 5 miles = 8 kilometres

tenrec

Question Author

Thanks Factor.

factor-fiction

Of course I meant 1 mile = 1.6 KILOmetres

tenrec

Question Author

Thanks Bibble and thanks again Factor. That has sorted it out for me.

1 to 6 of 6

Do you know the answer?