I don't use TAS, but if it creates a text file, you could do your import and
specify the each field the way you want.

If TAS dumps out a .csv file, you can rename it to .txt and you'll see the
data|text to columns wizard.

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?

--

Dave Peterson