July 7, 2016
I have a table that's several hundred thousand rows. It contains a date field like this: dd/mm/yyyy. When I summarize it with a Pivot Table, Excel adds fields for Year and Quarter, but the original date field won't display. Please see the attached sample file. This does not happen when the table is small.
How can I keep the original format?
April 21, 2015