Solving Date Problems in Excel PivotTablesAug 31, 2022
When importing data into Microsoft Excel, sometimes the date comes in as text instead of a true date format. You may not even notice until you are in a PivotTable and the dates aren't acting right. Try the Text to Columns and see if you can fix your dates so they will pivot for you!
Dawn Monroe Training
Microsoft Office Specialist Master
239 S Pattie, Suite #2
Wichita, KS 67211
PLEASE SUBSCRIBE for more tips!
#excelformatting #excel #exceltutorial #exceltips #microsoftexcel #excelpivottable #excelpivot
Join our mailing list to receive event schedules, articles and news.
Don't worry, your information will not be shared.
We hate SPAM. We will never sell your information, for any reason.