An Excel Tutorial for Converting Miles per Hour to KM per Hour.

Posted on June 13, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - An Excel Tutorial for Converting Miles per Hour to KM per Hour.

And we are closing the week with another Microsoft Excel Tutorial. I want to show you with this Excel Tutorial how you can convert miles per hour to kilometers per hour and it’s pretty simple.

If you want to convert miles per hour to kilometers per hour you’ll need to follow the next steps.

I’m starting this Excel tutorial with this column.

Excel-tutorial-converting-miles-km-hour-pic1

Then you’ll need to fill in the conversion rate somewhere in your spreadsheet. I did this in C1.

Excel-tutorial-converting-miles-km-hour-pic2

Now select Cells B2:B9 and type in the following formula =A2/$C$1. And the other way around is =A2*$C$1

Excel-tutorial-converting-miles-km-hour-pic3

And press CTRL+ENTER

All you have to do now is select Cells B2:B9 again, right click and select properties. Now you the number tab because you might want to have your digits in a 2 decimal number.

Excel-tutorial-converting-miles-km-hour-pic4

That’s it for today and for this week. I hope you all enjoyed this week and I’ll talk to you all next week. Have a great weekend.

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.