View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Hexadecimal to Decimal (and vice versa)

Hi,

I think you'll have to explain why you think Excel is getting it wrong
beccause I prefer the Excel answer to yours.

368847dd = 914900957 and not 5408931293

Mike


"Toria" wrote:

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!