| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom filter will not return characters between 1-9 inclusive
I have an alphanumeric column for which I am attempting to filter for all
numeric between 1-9. If I try "greater than or equal to 1" AND "less than or equal to 9" I get NO rows, even though there are values from 1-9. Even trying just "less than or equal to 9" returns no rows. What am I missing here? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom filter will not return characters between 1-9 inclusive
Please avoid multi posting, one group is normally enough and if not cross
post instead since the people who answer can see it has been posted in multiple groups Your numbers are probably seen as text, make sure there is no alignment in the cells, the default for text is left aligned so if your numbers are left aligned they are text, did you import them (that is a often a problem with numbers seen as text)? You can try to convert them to text, make sure the format in the cells are general, then select the range with numbers and do datatext to columns, then click finish, now try it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "William" wrote in message ... I have an alphanumeric column for which I am attempting to filter for all numeric between 1-9. If I try "greater than or equal to 1" AND "less than or equal to 9" I get NO rows, even though there are values from 1-9. Even trying just "less than or equal to 9" returns no rows. What am I missing here? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom filter will not return characters between 1-9 inclusive
The data is imported and the numbers are left-justified. I am not quite sure
what you meant by "datatext". I sorted by this column, changed to "General" the selected the numbers (still left-justified) and changed them from general to "text", but the custom filter still does not function as expected. "Peo Sjoblom" wrote in message ... Please avoid multi posting, one group is normally enough and if not cross post instead since the people who answer can see it has been posted in multiple groups Your numbers are probably seen as text, make sure there is no alignment in the cells, the default for text is left aligned so if your numbers are left aligned they are text, did you import them (that is a often a problem with numbers seen as text)? You can try to convert them to text, make sure the format in the cells are general, then select the range with numbers and do datatext to columns, then click finish, now try it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "William" wrote in message ... I have an alphanumeric column for which I am attempting to filter for all numeric between 1-9. If I try "greater than or equal to 1" AND "less than or equal to 9" I get NO rows, even though there are values from 1-9. Even trying just "less than or equal to 9" returns no rows. What am I missing here? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom filter will not return characters between 1-9 inclusive
Simply re-formatting will not change these to numbers.
Peo suggested going to Data on the Menu and selecting Text to Columns First select your data range then DataText to Columns and hit "Finish" Should do the trick. Gord Dibben MS Excel MVP On Thu, 27 Jul 2006 11:41:53 -0700, "William" wrote: The data is imported and the numbers are left-justified. I am not quite sure what you meant by "datatext". I sorted by this column, changed to "General" the selected the numbers (still left-justified) and changed them from general to "text", but the custom filter still does not function as expected. "Peo Sjoblom" wrote in message ... Please avoid multi posting, one group is normally enough and if not cross post instead since the people who answer can see it has been posted in multiple groups Your numbers are probably seen as text, make sure there is no alignment in the cells, the default for text is left aligned so if your numbers are left aligned they are text, did you import them (that is a often a problem with numbers seen as text)? You can try to convert them to text, make sure the format in the cells are general, then select the range with numbers and do datatext to columns, then click finish, now try it -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "William" wrote in message ... I have an alphanumeric column for which I am attempting to filter for all numeric between 1-9. If I try "greater than or equal to 1" AND "less than or equal to 9" I get NO rows, even though there are values from 1-9. Even trying just "less than or equal to 9" returns no rows. What am I missing here? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom filter does not work correctly | Excel Discussion (Misc queries) | |||
| Return first 'n' characters | Excel Worksheet Functions | |||
| How to return # characters based on 2nd instance of value | Excel Worksheet Functions | |||
| how do i filter data by number of characters in excel? | Excel Discussion (Misc queries) | |||
| Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions | |||
Linear Mode
