Home

Excel parses text filter as a date

Highlighted
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
Highlighted

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

Related Conversations
Excel Data Validation Condition
Annybuh in Excel on
0 Replies
Excel on iPad
Mattlewis in Excel on
1 Replies
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies
2 Seniority Lists
Aminam20 in Excel on
9 Replies