Decimal to Hexadecimal
DEC HEX
02313552326 17cecac6
Hi. Your company breaks the Dec number into 2 parts.
23 & 13552326
23 is 17 hex
13552326 is cecac6 hex
--
HTH :)
Dana DeLouis
Windows XP & Office 2003
"Sean Timmons" wrote in message
...
So, my company tracks items based on DEC and HEX, some with one, some with
the other. I'm tryign to create a formula that will convert items that
have,
say DEC to HEX and vice versa. Problem is, when I attempt DECTOHEC and
HEXTODEC, it doesn't match what I get using my company's lookup tool (an
arduous process)
Here's what the company conversion are for a sample set of numbers:
DEC HEX
02313552326 17cecac6
02313552451 17cecb43
02313552469 17cecb55
02313552512 17cecb80
02313552538 17cecb9a
02313552779 17cecc8b
02313552798 17cecc9e
02313552829 17ceccbd
02313552891 17ceccfb
02313552900 17cecd04
05112837432 33C3E238
And Dec2Hex() gives me:
DEC HEX
02313552326 89E601C6
02313552451 89E60243
02313552469 89E60255
02313552512 89E60280
02313552538 89E6029A
02313552779 89E6038B
02313552798 89E6039E
02313552829 89E603BD
02313552891 89E603FB
02313552900 89E60404
05112837432 130BFB538
I'm missing something... :-/
|