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
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies