Pivot Table - Date converts wrong!

[J Lowe]

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

What's in C2?

 

[J Lowe]

C2= 0399

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

Thanks,
Jason

 

[J Lowe]

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