Creating a custom Date format
Posted by Ben on July 09, 2001 5:17 AM
I have information coming in from a web query and the format that the data comes in is Jul0901, meaning July 9, 2001. The Month is always the first three letters of the month, then the date, and then the last two digits of the year. Is there any way I can specify excel to interpret this data as a date, not just as a string? Thanks