▲ 5 r/excel
Hi. Complete novice here. I have a dataset the has headers containing dates in year format example 1987. However when T custom.format this to yyyy excel does not seem to recognize it in my pivot table as it thinks it needs to count from 0 till 1987.
What am I doing wrong?
u/Key_Relative1594 — 14 days ago