Using Excel 2000. Imported data from TAS, an accounts package. The data is
imported in csv format in Excel. The dates in the dd/mm/yy format have been
recognised as UK, but the dates picked up as dd/mm/yyyy are all in USA
format, i.e. mm/dd/yyyy, despite all being entered in TAS as dd/mm/yy.
Without going through the whole column's transactions individually & changing
the USA ones, is there a way to do this with all the USA dates?
Bookmarks