convert measurement units in Excel

Q28. Is there a way I can convert between units of measurement 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 find the least common multiple using Excel?

2) How can I remove all nonprintable characters from text?

3) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

4) How can I add a 3 Month Moving average Trend line to my line chart?

5) Vlookup to return multiple values in same cell in Excel

6) How do I change the rating numbers to rating labels?

7) How can I find the number of working days between 2 dates using VBA?

8) Is there a way I can average a range of numbers even if there is an error value in range?

9) How can I extract file name from a full path including folder path and file name?

10) How can I enter a cent symbol in a cell?

11) How can I use SUMPRODUCT to summarize my raw data?

12) How can I convert Column numbers into Column names for use in range definition?

13) Millions thousands custom number formatting in Excel

14) How do I get the principal part of loan payment for a period given Loan amount, Rate of Interest and period?

15) I work with a SW that returns Hex values - how can I convert them to decimal values?