View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Decimal to Hexadecimal

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