"mogulboy" wrote...
....
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

If these values are numbers formatted as "000000000000" (12 0s in sequence),
then the cell only APPEARS with the leading 0s, but they're not part of the
cell's contents or its value. You can ensure these numbers are converted
correctly by including a TEXT call.

=DEC2HEX(LEFT(TEXT(A2,"000000000000"),11))