Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Custom filter won't return charcters between 1-9 inclusive

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
William - 27 Jul 2006 18:15 GMT
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?
Peo Sjoblom - 27 Jul 2006 18:30 GMT
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 data>text to columns,
then click finish, now try it

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

>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?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.