Pivot Table - Date converts wrong!

J Lowe · Feb 25th, 2002, 01:42 PM

My dates are not transferring properly into my pivot table. Can anyone help by telling my why and what to do to keep the date format I have in my original data?

Here is an example of what all is going on:

Original data

1999 :formula (=DATE(RIGHT(C2,2),LEFT(C2,2),1))

Pivot table results

1900 :It converts to 1900, versus 1999

Mark W. · Feb 25th, 2002, 01:45 PM

What's in C2?

J Lowe · Feb 25th, 2002, 02:01 PM

C2= 0399

Where 0399 = date format imported from Access, from data imported from our mainframe system.

Thanks,
Jason

J Lowe · Feb 25th, 2002, 03:40 PM

I think that I may have solved the problem. I'm going to put it in the correct format before I export it to Excel which should solve the issue.

Thanks for the help.

Jason

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

Feb 25th, 2002, 01:42 PM	#1
J Lowe New Member Join Date: Feb 2002 Posts: 27	My dates are not transferring properly into my pivot table. Can anyone help by telling my why and what to do to keep the date format I have in my original data? Here is an example of what all is going on: Original data 1999 :formula (=DATE(RIGHT(C2,2),LEFT(C2,2),1)) Pivot table results 1900 :It converts to 1900, versus 1999

Feb 25th, 2002, 01:45 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	What's in C2?

Feb 25th, 2002, 02:01 PM	#3
J Lowe New Member Join Date: Feb 2002 Posts: 27	C2= 0399 Where 0399 = date format imported from Access, from data imported from our mainframe system. Thanks, Jason

Feb 25th, 2002, 03:40 PM	#4
J Lowe New Member Join Date: Feb 2002 Posts: 27	I think that I may have solved the problem. I'm going to put it in the correct format before I export it to Excel which should solve the issue. Thanks for the help. Jason