My doubt is kinda basic, but I'd much like to have some help.
I have a sheet with some data and I'm creatin a pivot table with this data. The problem I'm facing is that, although I have formatted the cells contining the date info equally, my pivot table gives different results for differente months. See, if I have 201901 in a cell, my pivot table gives me something like "Jan - 2019". But in february, it gives me the same format from the base sheet: "201902".
I have changed the category of the cells and I have used de format painter/brush and it doesn't work.