Pivot table date problem

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,784
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

Well-known Member
Joined
Jan 14, 2003
Messages
1,784
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
 

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,784
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
 
Last edited:

Forum statistics

Threads
1,082,510
Messages
5,365,988
Members
400,865
Latest member
LuciaRomo

Some videos you may like

This Week's Hot Topics

Top