Hello, Mike!
You wrote on Fri, 5 Jan 2007 12:40:02 -0800:

M Your Co conversions look dodgy to me and the results Excel
M comes up with can be verified here
http://www.statman.info/conversions/hexadecimal.html.

M Confused

M "Sean Timmons" wrote:

?? 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
??
?? I'm missing something... :-/

The Excel values seem correct to me, two different calculators
and the Windows calculator!

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not