Thanks for replying. TAS produces .csv files. I saved the file as .csv,
closed it. On re-opening I right-clicked to rename it & it brought up the
wizard. Followed this, putting in column breaks. After doing this once,
didn't need to use it again, as each .csv file on re-opening, dates were
automatically altered to UK formats. Then just converted the file to .xls!
Thanks for your help!


"Michelle, Mencap" wrote:

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?