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. |
|
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.

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

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

-
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.

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.


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.
Comments
One Response to “An Excel Tutorial for Converting Miles per Hour to KM per Hour.”
Leave a Reply















Very good tip. Thanks for this.