If you want to ignore the last digit, use
=DEC2HEX(LEFT(A2,LEN(A2)-1))

Remember that when Excel stores numbers as numbers, it doesn't store leading
zeroes (even if the cell is formatted to display them).
--
David Biddulph

"mogulboy" wrote in message
...
need help:
I am copying a bunch of 12 digit unique IDs over from Notepad into excel
and
I then need to convert a portion (the first 11 digits) of the number into
HEX.
Some of the unique IDs have one or two zeros in the beg of the values:
008453518958
011144250839
So I am using the DEC2HEX(Left(A2,11)) but I am not getting the right
results. It seems to be ignoring the zeros so for the first unique ID it
is
converting 8453518958...basically I want to ignore the last digit but am
having issues with the zeros