advanced filter format problem

[CG Rosén]

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

 

[Norman Jones]

Hi CG,

Try using a filter criterion like:

=VALUE(A3)>2