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
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