Please help me to convert the hexadecimal data

[Neha Miriyala]

Good Evening,
The cells in file contains hexadecimal data. I have tried to format it into text. But it didn't work. I also tried HEX2DEC formula.
Please help me with this problem.
.

 

[vletm]

Neha Miriyala​

Take care that those cells are formatted as General
I tested as below

There are some challenges to use Your sent picture.

 

[Neha Miriyala]

I tried but its giving me #NUM!

 

[vletm]

Neha Miriyala​

Did You take care formats?
Did You check that 'error'-note?
Could You send a sample file?
...without it - I could write that 'normal' file could work.

Syntax​

HEX2DEC(number)

The HEX2DEC function syntax has the following arguments:

• Number Required. The hexadecimal number you want to convert. Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Remark​

If number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.

 

[Neha Miriyala]

file is too large to upload.

 

[vletm]

Neha Miriyala​

How could a sample file be too large to upload?
Do You have any image, what would be that (fd7c28f9fd8045f2) value be?

You could modify above formula as Your needs Yourself.

 

[GraH - Guido]

Hmmm, That excel version seems modern enough to have Power Query on board.

I tried with the one value in the picture that's absolutely clear

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"some Hex", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.From(Expression.Evaluate("0x" & [some Hex])))
in
    #"Added Custom"

EDIT: added the example of Vletm. But I get other result.


Source: https://xxlbi.com/blog/converting-hexadecimal-to-decimal-numbers-in-power-query/

 

[Neha Miriyala]

after using the formula values looked like this as shown in the image

 

[vletm]

Neha Miriyala​

You seems to test reply #6 ... it gives values.
... but without answers or file.

 

[GraH - Guido]

Tried over here https://www.rapidtables.com/convert/number/hex-to-decimal.html?x=FD7C28F9FD8045F2
and seems my solution works:

 

[vletm]

GraH - Guido​

I didn't test it
... it seems to need some modifications.
Your non formula give better result.
Both below gives 18265519242872900000
=DECIMAL(B2,16)
=LET(L,LEN(B2),seq,SEQUENCE(L),SUM((FIND(MID(B2,seq,1),"0123456789ABCDEF")-1)*16^(L-seq)))
But ... Excel can show 15numbers and the rest are zeros.

Neha Miriyala​

How do You get those values?