WTF?? Converting dates from XP to 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ouch...When I read in a spreadsheet in XP, the dates and months are opposite
and all my date data gets messed up.

Seems that one is fomatted as dd-mm-yyyy, and the other is mm-dd-yyyy.

What is going on here, and how to fix it?
 
Probably fix by going into Windows Control Panel>Regional and Language
Options>Regional Options>Customize>Date.

Change your short and/or long date format here.

Gord Dibben Excel MVP
 
If it is a format change (either format|cells|number tab) or adjusting your
region settings, then ignore this.

But I'd format one of those opposite dates as MMM DD, YYYY just to make sure
that it's really a date and really the correct date.
 
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

Date Formats 1
Excel 2002: How to make the date format uniform ? 1
Convert dates stored as text 2
Formatting Dates from Text to Numbers 2
Date format changes in mail merge using Excel worksheet as data 2
convert date 1
Date Formatting Error 1
Changing date to eliminate day in format mm/dd/yyyy 1

Back
Top