ExcelBanter - Excel 2007, pivot table format issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2007, pivot table format issue (https://www.excelbanter.com/excel-worksheet-functions/250559-excel-2007-pivot-table-format-issue.html)

John F

Excel 2007, pivot table format issue

Suddenly the numbers in my pivot tables are reverting to dates! I can
reformat to numbers but on refresh they revert to dates. Help please?

All times are GMT +1. The time now is 07:18 AM.