Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I change a column of dates from USA to UK format?
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
I find it simpler/safer to just rename the file to .txt, but glad it worked for
you. Michelle, Mencap wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
How do I change column (A) to say First Name? | Excel Discussion (Misc queries) | |||
how can I change the a,b,c, column headers in excel to names | Excel Discussion (Misc queries) | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Seach Column and return multiple dates to another worksheet? | Excel Worksheet Functions |