You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter Neha Miriyala
- Start date

I tested as below

There are some challenges to use Your sent picture.

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.

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.

file is 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.

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

Code:

```
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/

... but without answers or file.

and seems my solution works:

... 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.

Last edited: