Missing a zero

I have this formula in cell D15

="A1D" & C21

In C21 there will be a number from 1 to 21. I have the cell formated so it shows two digits. So if the number is 6 it will show as 06.

I need it to show the same way in D15. So if the number is 6, it shows a value as A1D06. It works fine if the number is 10-21.


Thanks for help.

Try

="A1D" & TEXT(C21,"00")

Awesome. Thanks

You're welcome.