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

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.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"PL" wrote:

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

Hi

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

Thank you

"PJFry" wrote:

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.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"PL" wrote:

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

I tried ="&A2, it didn't work.

Try it with 2 double quotes:

=""&A2

=A2&""


--
Biff
Microsoft Excel MVP


"PL" wrote in message
...
Hi

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

Thank you

"PJFry" wrote:

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.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"PL" wrote:

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