G
Guest
A co-worker created a spreadsheet with dates keyed in a column as text (e.g.,
'12-03 represents December 2003). I need to convert a very long column of
these "dates" to actual dates in the format MM-YY. Everything I try converts
it to the proper month, but year 05 (2005).
Your help is appreciated.
'12-03 represents December 2003). I need to convert a very long column of
these "dates" to actual dates in the format MM-YY. Everything I try converts
it to the proper month, but year 05 (2005).
Your help is appreciated.