Keeping a two digit number when it is 1-9

[mattress58]

I have the following

Please Login or Register  to view this content.

AK5 value will be 2 - 21.

I need it to display

A1D05

or

A1D21

or whatever the number is after A1D, but when AK8 = a value of 1 or 2 or 3...... It comes back as A1D1 or A1D2... How ca I keep the two digits in AK8 to stay and put the value the way I want in AE5

[mattress58]

This line above
AE5 value will be 2 - 21.

I mean AK8 value will be 2-21

[nilem]

try

Please Login or Register  to view this content.

[mattress58]

Thanks, that worked perfect.

[mattress58]

If I put that in a formula

="A1D"&AK8

do you know how I could do the same thing and keep those digits

[nilem]

something like

Please Login or Register  to view this content.