Pivot table date problem

[srizki]

Hi all,
I copied many the heading from many spreadsheets on of the column headings was the date; it was like 08/06/18, two digits year. After copying over 60 headings and created a pivot table, it shows year as 1918 and 1919 instead of 2018 and 2019. Hmm, What went wrong and how do I correct it.

Thanks.

 

[srizki]

I found out the problem, but I do not know how to fix it. The dates were in text, and it gave an option to convert dates to XX19 or xx20, I selected xx19. Now how do I reverse it, so I can select XX20.

Thanks

 

[mole999]

could you find 19 replace with 20

 

[srizki]

There are so many and if I use find and replace it will replace all 19 to 20 I only want to replace 1917 1918 and 1919 to 2017, 2018 and 2019.

Update:
I did use the find and replace, 1918 to 2018 and 1919 to 2019 one at a time and it worked.
Thanks