Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FirstName, LastName and vice versa | Excel Worksheet Functions | |||
I want columns of worksheet to become rows and vice-versa. | Excel Worksheet Functions | |||
Switching Subcategories into Categories and Vice Versa | Excel Worksheet Functions | |||
From pricelist to productslist and vice versa... | Excel Discussion (Misc queries) | |||
How do I reference a worksheet name in a cell, or vice versa? | Excel Discussion (Misc queries) |