Hello,
I have dates in the following format in an Excel column:
MM/DD/YYYY
the YYYY is not a problem but the months of January(01) to Sep(09) and the days from 1 to 9 are a problem in that I need to add a ZERO in front of the single digit to make them a double digit.
For example,
1/3/1950 should be 01/03/1950
7/9/2003 should be 07/09/2003
How do I go about adding ZERO's in single digits of months and days to make them DOUBLE digits?
Any help would be appreciated,
Thanks,
Al
I have dates in the following format in an Excel column:
MM/DD/YYYY
the YYYY is not a problem but the months of January(01) to Sep(09) and the days from 1 to 9 are a problem in that I need to add a ZERO in front of the single digit to make them a double digit.
For example,
1/3/1950 should be 01/03/1950
7/9/2003 should be 07/09/2003
How do I go about adding ZERO's in single digits of months and days to make them DOUBLE digits?
Any help would be appreciated,
Thanks,
Al