Home

Excel parses text filter as a date

d_wasserman
Occasional Visitor

I have a spreadsheet that includes a column of dates in a format that Excel doesn't recognize, so I'm treating them as text. I created a Text Filter to select values that begin with 2017-01-1. It selected 0 rows, even though the column includes cells that start with 2017-01-1. I brought the Custom AutoFilter dialog box back up, and found that Excel had changed 2017-01-1 to 1/1/2017. This is a bug: it's a text filter, not a date filter, so it should not be parsing 2017-01-1 as a date.

1 Reply

@d_wasserman , if you stay on any cell with 2017-01-1, what do you see in formula bar?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies