I'm trying to add the text S- to the beginning of the cell contents at the beginning of a birthday formatted as mm/dd/yyyy. I have the column formatted with the leading zeros but when I use the formula ="S-" & A1 it drops the leading zeros. I've tried all kinds of formatting options and they haven't worked.
Here is an example.
S-10212002 (birthday is Oct 21 ,2002)
S-6222004 (birthday is Jun 22, 2004)