Convert hex values into decimal in Excel

For example, the value returned by SW is Hex "2A9C". In Excel, how do I convert this into Dec.

To do it in Excel, here is the answer:

a) Enter the formula =HEX2DEC("2A9C") in an empty cell as shown below. The formula returns Decimal value for the Hex input.

Note: The Hex value has to be entered within quotes.

excel convert hex values into decimal


You can find similar Excel Questions and Answer hereunder

1) Split string into multiple columns in Excel

2) How can I have text autocomplete based on values previously entered in Column?

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

4) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

5) Generate a list of unique values in Excel

6) I have angle values in radians. In Excel, how can I convert them to degrees?

7) Is there a way I can convert between units of measurement in Excel?

8) Split one long column into multiple smaller columns in Excel

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

10) Remove the apostrophe cell text values in Excel


Here the previous and next chapter