I am trying locate a function to cleanup dates in an excel spreadsheet so that all of the dates are in the following format: mm/dd/yyyy
Currently the formats vary, here are some examples:
1/1/97
01/04/92
3/12/1999
I wanted them to look like the following:
01/01/1997
01/04/1992
03/12/1999
Currently the formats vary, here are some examples:
1/1/97
01/04/92
3/12/1999
I wanted them to look like the following:
01/01/1997
01/04/1992
03/12/1999