Home

Excel parses text filter as a date

Highlighted
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
Formule Si
Kevin13800 in Excel on
0 Replies
Multiple Conditional Formatting
Ray_Ray in Excel on
1 Replies
IF Function
Zaharyshka8 in Excel on
2 Replies
Changing Data Source
cjkim92 in Excel on
0 Replies
Convertion d'heure
Philaos-49 in Excel on
1 Replies
Copying work sheet form with formulas
Allsons in Excel on
1 Replies