Hello,
I have a Pivot table that is oddly changing the data type from the original type (numbers) to a new type (dates)..once you double click on the data in the table...
I have enclosed the file.....
What is happening is, A pivot table was made from a range of cells, and even though the original data that the Pivot table is grabbing is formatted as a number, when you double click on a cell in the pivot table and it opens up a new sheet and shows the data, those number cells/fields turn into dates??
To be more specific: Columns D and F (styles and orders) are formatted as dates (when looking at the data that is being pulled from the pivot table) but they should be numbers….they are formatted as numbers on the sheet where the data is pulled from, so I can't figure out why it is changing its type once it comes via the pivot table?
Any help is greatly appreciated...!
babs
Bookmarks