View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers[_2_] Meebers[_2_] is offline
external usenet poster
 
Posts: 36
Default Hexadecimal to Decimal (and vice versa)

using my "old" casio calculator 914900957 =368847dd
"Toria" wrote in message
...
Hello,

I know the formulas of HEX2DEC and DEC2HEX. I think my problem is not
really knowing about the math.

I received a hex and dec version of a device version:
Hex: 368847DD
Dec: 5408931293

When I do the above formulas in Excel, the result is different. If I take
the Hex version, 368847DD, and do HEX2DEC, I get 914900957 when it should
be
5408931293.

If I take the Dec version, 5408931293, and do DEC2HEX, I get 14265BDDD
when
it should be 368847DD.

I feel like I'm missing something very obvious but can't figure it out.
Help is much appreciated!