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