Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |