Pivot Table: Group: Date - Error in Conversion

J Lowe · Feb 19th, 2002, 10:53 AM

Well, day two and I have another issue dealing with the same data I have been using in another posting.

I am working with a Pivot Table trying to sum a range of data by years. The data is entered as mm/yy. When I try to group the data together by year to get a sum for that year, the grouping changes the date, but incorrectly.

For example:

00
01
02
99

These dates change to:

1900
1901
1902
1999

I have checked my cell content and the cells are Custom/mmdd.

Any suggestions?

Thanks again,
Jason

Corni · Mar 18th, 2002, 09:54 PM

You have to change the way two-digit years are interpreted. For Win98 or 2000 go to Control Panel|Regional Settings(Options)|Date and change the upper limit for the century.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 10:53 AM	#1
J Lowe New Member Join Date: Feb 2002 Posts: 27	Well, day two and I have another issue dealing with the same data I have been using in another posting. I am working with a Pivot Table trying to sum a range of data by years. The data is entered as mm/yy. When I try to group the data together by year to get a sum for that year, the grouping changes the date, but incorrectly. For example: 00 01 02 99 These dates change to: 1900 1901 1902 1999 I have checked my cell content and the cells are Custom/mmdd. Any suggestions? Thanks again, Jason

Mar 18th, 2002, 09:54 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	You have to change the way two-digit years are interpreted. For Win98 or 2000 go to Control Panel\|Regional Settings(Options)\|Date and change the upper limit for the century.