Convert measurement units in Excel

For example, I want to convert 34.5 miles in my Excel worksheet to kms or 35 deg C to Fahrenheit.

To do it in Excel, here is the answer:

a) Enter the formula =CONVERT(C2,"mi","km") where C2 corresponds to distance data in "Miles".

excel convert measurement units

b) Similarly, enter the formula =CONVERT(C7,"C","F") where C7 corresponds to Temperature reading in "Degrees Celsius".


You can find similar Excel Questions and Answer hereunder

1) How can I insert a watermark in my Worksheet?

2) Highlight row of selected cell in Excel

3) What are the main sheet objects and what can the objects do in the sheet in VBA

4) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

5) How can I generate random numbers between 2 limits?

6) How can I add interval to dates?

7) How can I change the Marker size and Marker line color for all the series in a chart?

8) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

9) Here some explanations about the XML DOM node in VBA, DOM stands for Document Object Model

10) How to create a subroutine in Excel VBA. Subroutines explained


Here the previous and next chapter