• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Converting US to Europen date formats

Peter Brannick

New Member
Hi

I recieve excel reports from the US (I'm in Italy) thatt have the date AMerican style, ie MonthDayYear (eg 18th Nov 2009= 11/18/2009). Problem is that my Euro excel is set up for Euro format dates (eg 18th Nov 2009= 18/11/2009).

I can read the dates, but the problem comes when I put everyting into a pivot table. My Euro excel reads the dates as if they were Euro format, so the order might be as follows: 11/18/2010 (US 18th Nov), 12/18/2010 (US 18th Dec).

How can I either:

a. COnvert the US dates to Euro dates, ie invert day/month (so that ecxel puts them in the correct chronological Euro order) OR

b. Hatchet my Euro excel so that it thinks it's American (putting the dates in columns in the correct order US style)

Cheers

Peter
 
Back
Top