LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 38
Default Hexadecimal to Decimal (and vice versa)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FirstName, LastName and vice versa Bob Excel Worksheet Functions 3 October 27th 06 06:54 PM
I want columns of worksheet to become rows and vice-versa. Swapping rows and columns Excel Worksheet Functions 1 June 10th 06 06:03 AM
Switching Subcategories into Categories and Vice Versa [email protected] Excel Worksheet Functions 7 April 17th 06 03:23 PM
From pricelist to productslist and vice versa... Herman56 Excel Discussion (Misc queries) 0 March 29th 06 05:40 PM
How do I reference a worksheet name in a cell, or vice versa? ilmeaz Excel Discussion (Misc queries) 2 May 2nd 05 08:38 PM


All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"