Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hexadecimal to Decimal (and vice versa)
I get 914900957 every time, Excel, calculator, and manually
-- __________________________________ HTH Bob "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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hexadecimal to Decimal (and vice versa)
You'll have to explain why you think that those numbers are incorrect, and
how you get your alternative figures. The values which HEX2DEC and DEC2HEX give agree with what the Microsoft calculator's conversions give, and you can also check by converting each digit at a time and adding up the values of the digits. Taking just part of the problem, you've got hex 368847DD. Well, hex 30000000 is 3 * 16^7, which is 805306368, so it wouldn't make sense to get 5408931293 for the whole number 368847DD. If you want to add up the total 368847DD comes to 3 * 16^7 + 6 * 16^6 + 8 * 16^5 + 8 * 16^4 + 4 * 16^3 + 7 * 16^2 + 13 * 16^1 + 13 * 16^0 hence the total of 914900957 -- David Biddulph "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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hexadecimal to Decimal (and vice versa)
Thanks to all four of you for your responses! That was the confirmation I
needed. A customer stated that the numbers were incorrect. Clearly, that's not the case. David, thank you also for typing out the conversion. This helps me a lot! "David Biddulph" wrote: You'll have to explain why you think that those numbers are incorrect, and how you get your alternative figures. The values which HEX2DEC and DEC2HEX give agree with what the Microsoft calculator's conversions give, and you can also check by converting each digit at a time and adding up the values of the digits. Taking just part of the problem, you've got hex 368847DD. Well, hex 30000000 is 3 * 16^7, which is 805306368, so it wouldn't make sense to get 5408931293 for the whole number 368847DD. If you want to add up the total 368847DD comes to 3 * 16^7 + 6 * 16^6 + 8 * 16^5 + 8 * 16^4 + 4 * 16^3 + 7 * 16^2 + 13 * 16^1 + 13 * 16^0 hence the total of 914900957 -- David Biddulph "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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |