I have the following
AK5 value will be 2 - 21.Range("AE5") = "A1D" & Range("AK8").Value
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
Bookmarks