View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CG Rosén CG Rosén is offline
external usenet poster
 
Posts: 74
Default advanced filter format problem

Good Evening,

Trying to use the advanced filter to a column with lengths logged as:

6,25
2,36
4,25
1,55
etc

the data are in text format. In the criteria field I try to use 2,00 to
obtaion the lengths
over 2,00. This seems to work when the data are in general format but not in
the text format.
Is there a way to solve this without converting my text data to some other
format?

Brgds

CG Rosén

uld like to extract all dates after a given date (for example 20051201)
by using an advanced filter. Is this possible?

Best regards

CG Rosén