Now, that was some good calculating! thank you su much for figuring that out!
It was driving me silly!

"Dana DeLouis" wrote:

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... :-/