How to convert US date format to European

  • Thread starter Thread starter TMeisner
  • Start date Start date
T

TMeisner

My computer is set up to use the European style dates (ddmmyyyy), not the
USA-style dates (mmddyyyy format). So if I enter "01/06/05" I get a date of
01-June-2005. However when I download some information in CSV format at
times that same date is formatted like this: "06/01/05". However this is
interpreted as 06-January-2005 in the spreadsheet. How can I convert the US
formatted values to European, in effect swapping the first two numbers?

Thanks

T Meisner
 
Rename the .csv file to .txt

File|open that .txt file
You'll see the text import wizard pop up and you can supply the data format you
want dmy or mdy or ydm or...
 
Worked great !! Thanks a lot, I never would have found that.

TMeisner
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting european date format to US format. 2
Converting and sorting US dates into European format? 9
Max Value in Year 3
Which is the best MBOX Converter Tool different formats conversion? 4
How do I auto-convert European dates to US dates? 2
Problem formatting dates from CSV file 2
How to enter start and end date/time in excel based on some specific value. 7
How to convert decimal year to date format in excel 2

Back
Top