This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have an excel sheet with a table that has a date column. Originally the dropdown filter in date column was showing the dates by month like January, February and I could expand it show the day. I added more information to the table and now when I go to filter the column it shows check boxes for the months like January, February but below it, it shows addtional check boxes for the mm/dd/yyyy format separately for some rows (I assume the rows I added). How do I fix this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Answer accepted by question author
Hi,
Type 1 in any cell and copy it. Select all entries in that column, right click Paste Special > Multiply. Reformat the entries as Date.
Hope this helps.
Wow... you are magic. That's amazing!
Thank you for your reply. What I've found is just the act of clicking in the box and pressing enter fixes the formatting for each one but since I have so many I was wondering if there was a faster way to fix it.
Hi,
There are spaces or some other specials in the cells which are not getting grouped. Clear those special characters and all should be fine.