| 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? |
| 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 | |||
Threaded Mode
