Auto filter

P

PL

I have a column with numbers running from 1- 100, I used custom autofilter to
find all numbers beginning with 1 but it returned only all the empty rows,
why is that so?

Thanks
 
P

PJFry

It has to do with the way that Excel views the numbers. Simply put, 100 is
100 versus a word, say 'dog', which can be broken up into d-o-g. Filter by
the first character of a cell, that cell must be a text value.

Assuming your number column runs from A2 to A101, you can put in a formula
in column B that converts those values to a text. In cell B2 enter:
="&A2 and copy that formula to the end of your range. Then do the filter on
column B and it should work.

Post back with questions.
 
P

PL

Hi

Thanks . But what's the formula to convert numbers into text? I tried ="&A2,
it didn't work.

Thank you
 
Top