I am trying to copy and paste dates from a PDF in the format, Jul-94 which represents July, 1994 (doesn't matter which day). I am using the text to columns tool to parse the data, and selected MYD for the date column, but it still isn't reading in the dates correctly. It handles all dates before 2001 ok; it converts Jul-94 to 7/01/1994. However for a date such as Dec-13, it is converting it to 12/13/2014 when it should be 12/01/2013. Is there any way to correct this problem?
thanks!
Bookmarks