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.
Bookmarks