Is it a possible to convert the following 'text' formatted sequence to a date?
070501 to 05/01/07 or 05/01/2007
070613 to 06/13/07 or 06/13/2007
I have some spreadsheets that were copied and pasted from various databases, I am looking to combine to a single spreadsheet, but need all of the various components in the same format first...
Thanks!
Bookmarks