Hello everyone,

I have three sheets labeled 2013, 2014, and 2015 that has data from each of those years in a table. They are formatted exactly the same including column numbers and number formatting. The last column for each table has a percentage category, but for some reason the percentages in the 2015 table are recognized as dates and times when making a pivot table (ex. 0% is shown as 12:00:00 AM). The sheets are joined together as an sql query pivot table. I've tried just about everything with number formatting and deleting and reentering the data. Any suggestions would be appreciated.

Thanks