Can I change a column of dates from USA to UK format?

  • Thread starter Michelle, Mencap
  • Start date
M

Michelle, Mencap

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?
 
D

Dave Peterson

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.
 
D

Dave Peterson

I find it simpler/safer to just rename the file to .txt, but glad it worked for
you.
 
Top