HEX2DEC - Leading 0's

[RWOLD]

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.

[NBVC]

Try:

=CONCATENATE(TEXT(HEX2DEC(LEFT(A2,2)),"000"),TEXT(HEX2DEC(RIGHT(A2,6)),"00000000"))

[RWOLD]

Try:

=CONCATENATE(TEXT(HEX2DEC(LEFT(A2,2)),"000"),TEXT(HEX2DEC(RIGHT(A2,6)),"00000000"))

Thank you! This works.

[NBVC]

Great.

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save