When using a "Contains" AutoFilter dropdown on a column of data cells formated numerically will not properly identify substrings.
Example:
Column 1
1234 <-- formatted as number
x1234
y1234
AutoFiltering for Contains "123" will return:
x1234
y1234
This could be by design, but it's still LAME.
No comments:
Post a Comment