LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default advanced filter and format


Good day Group,

Have a problem concering advanced filter and formats. In a column there is
data
representing dates. The data are put in the column by textboxes, the column
is formated
as text.
Date
20060201
20060225
20050303
20040815
20060525
etc

When trying to filter by the advanced filter there is nothing found by using
criteria like:
Date
<=20050101
but is working when the criteria looks like:
Date
<=20050101*
have checked the length of the textstring and there are no "hidden" letters
or spaces.
It also looks like <= operand is working fine but when using the = the data
that is =
to the criteria is ignored.

Hopeful for some hints how to go on with this problem

Brgds

CG Rosén







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why won't advanced filter return filter results? jaws4518 Excel Worksheet Functions 5 September 12th 06 06:11 PM
advanced filter format problem CG Rosén Excel Programming 1 June 5th 06 02:24 AM
How do I use advanced filter to filter for blank cells? Monique Excel Discussion (Misc queries) 2 March 21st 06 06:43 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM


All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"