Hi,
I am working on a project that requires me to convert hex serial numbers into dec while retaining leading zeroes in two segments.
The serial numbers are basically 8 characters, XX-YYYYYY, and convert into DEC values that are 11 characters ###-######## (2 - 6 into 3 - 8)
I was trying to use =CONCATENATE(HEX2DEC(LEFT(A2,2)),HEX2DEC(RIGHT(A2,6)))
This obviously produces the incorrect answer most of the time due to the missing leading 0's in both segments, but I can't figure out the correct code.
I tried to attach my sheet, hopefully that works.
Bookmarks