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

advanced filter format problem
 

Hi CG,

Try using a filter criterion like:

=VALUE(A3)2


---
Regards,
Norman



"CG Rosén" wrote in message
...
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