convert Hex values into decimal in Excel

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

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) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

2) How can I activate a routine when there is a change in value of a cell?

3) Given a raw data Table, how can I find the value of a field for a specific value of another field?

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

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

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

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

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

9) Generate a list of unique values in Excel

10) How can I avoid a gap in a line chart for missing data?

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

12) How can I change the meta-data of file (Author, Company Name and the like)?

13) How to freeze a row or column in Excel

14) Split string into multiple columns in Excel

15) How can I quickly navigate to a frequently used field in a voluminous worbook?