Pivot Table and Cell Type won't save formatting when refreshing

Hi Everyone,

So the problem I am having is that the cell type of my columns are changing everytime I refresh. The formula is correct, but I need to update the cell type to "Number" or "Text" to view it properly.

I have a spreadsheet that is connected to an Access Database. In this spreadsheet, I added some columns to calculate some things. Specifically, I have a "DateCalled" column that is from the database, and I created columns next to it so that I can see the month and year as separate entities. I did this so I can create the pivot table by month and year.

To be specific:
Column C= "DateCalled", cell type is Date. This is the date when people call in the office, from a database
Column D="DateCalledYear", cell type is number. I have a formula for this =IF([@DateCalled]>=1,MONTH([@DateCalled]),"")------works just fine.

When I format the cell type to Number for column D, it gives me the year of the cell from Column C. After I save&close, I reopen the file and the cell type changes to "General" and gives me a random date like 8/1/1905.

When this occurs, it affects my pivot table. I don't understand what I did wrong, since the formulas are calculating without a problem but I would need to reformat the cell type everytime so that it gives me the right numbers.

yes, it is checked off

When I select the columns and change the alignment to center (just to organize it), it changes the cell type for SOME to the correct one. In the same column, some cells are in the number type, while others are in the date type.