Excel – How to convert a hex number to a decimal number in Excel

conversionhexadecimalmicrosoft excel

I have a cell containing this value:

0x00006cd2c0306953

and I want to convert it to a number.

I tried:

=HEX2DEC(C8)

where C8 is the cell containing my hex value.

I get a #NUM error.

What am I doing wrong?

Best Answer

You could simply use:

HEX2DEC(right(A1,(len(A1)-2)))

len(A1) gives you the length of 0x string. Exclude the length of 0x, the remaining string is the hex number. Use Excel function to get the dec.

Related Solutions

Excel – how can I convert HEX numbers into Text in Excel 2007

Use & to concatenate text.

="0x"&DEC2HEX(A1)

Excel number format to convert number of month to name of month

To use any type of format, Excel needs to understand what the number means. There is no basis for Excel to know that 1-12 means Jan-Dec. This means that you need to add functions or some other basis to translate it if you want that cell to display it as a month. Bottom line, there is no way to have a cell contain just the number and display it as a month.

You can use a second cell with the translation, as has been discussed. An alternative is to do it the other way around--store the value in a form Excel can display as a month and then use a function in the formula that references it to translate that back to a number.

Best Answer

Related Solutions

Excel – how can I convert HEX numbers into Text in Excel 2007

Excel number format to convert number of month to name of month

Related Question