•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#large dataset processing
#dates
#format
#excel
#year
#custom.format
#dataset
#pivot table
#1987
#headers
#recognize
#count
#data entry
#novice
#user
#incorrect