Formatting keeps changing in pivot table filters.

[BRG_ATS]

Every month I dump new date in an excel sheet and refresh the data. The problem is on of the filters on my pivot tables is a date and when I refresh with the new data the formatting getting changed to General so my dates become numbers. I keep right clicking on the cell to change the format back to how I need it but it never fails to switch back to general when I refresh the new data.

[#2]

@BRG_ATS 

This method is working for me. To move your mouse over column header in pivot table until it changes to black arrow, then click column header to select whole column. Once the whole column is selected, you may proceed to format cell. This method is also working perfectly even you use conditional formatting. Please take note that in some cases, you may need to select more than one column for this method to work.