Aug 06 2021 11:19 AM
Hello all, I'm using Microsoft Excel in 365. I've got a data table that I use to create multiple Pivot Reports. Some times my dates are reflected as a number in the Pivot Report Filter and I need it to reflect the date. Any suggestions for this? The Columns in the table for the dates are formatted as a date.
Aug 06 2021 11:40 AM
Aug 06 2021 01:01 PM
Aug 07 2021 03:59 AM
Is it possible exactly the same but as Excel file? Perhaps you have mix of texts which looks like date and actual dates. Hard to say without the file.