1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I format my dates correctly?

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?

submitted by /u/Key_Relative1594
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article