Convert Decimal To Hexadecimal

[#1]

Hello,

I got a problem in converting a minus decimal number into an hexadecimal number.

Input: -1073741703
Ouput: FFFFFFFFC0000079

If I'm converting this in the MS Calculator i got the right number, if i use the formula "num(-1073741703), '(HEX)')" i got a 3FFFFF87.

Maybe someone other has a solution for me?

[#2 · Accepted solution]

Hi

did not work with a 64 bit number but with 48 bits

=num(pow(2,48) - 1073741703,'(HEX)')

Regards

Jürg

[#3]

Works perfect, thanks!