Share via

Excel Date format issue for generating pivot tables

Anonymous
2025-01-16T15:37:24+00:00

I have an excel workbook with a large amount of data. When I convert to a pivot table, one of the rows does not change into "Date" format, but instead remains as "General". in my pivot table. As a result I am unable to generate reports based on just months in my pivot table. Can you please let me know how to resolve this issue ? Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. riny 20,530 Reputation points Volunteer Moderator
    2025-01-17T06:29:05+00:00

    If there are only a few such 'dates' I would just re-enter them after ensuring that they cells are formatted as Date. If you have many such FALSE dates, look into Text-to-columns on the Data ribbon.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-17T14:03:21+00:00

    Thank you for your reply. I have dates before year 1901 in the original data. Will this be a problem when converting to pivot tables ? Thank you.

    0 comments
  3. riny 20,530 Reputation points Volunteer Moderator
    2025-01-17T14:29:03+00:00

    The Excel calendar start at January 1, 1900. Any date before that would not be recognised as a date. After that date will not be a problem.

    0 comments