M
Martin
Using Excel 2000.
I have a column, formatted as text, with the following:
Heading
02
01
05
04
03
(that's zero 1, zero 2 etc).
Ultimately I want to filter the values to show those greater then xx
and less than yy. However, for now I'm just trying to get the first
part to work.
I have tried using Custom filter :
If I enter Equals 02, all is well. However, if I specify Is greater
than 02, no rows are returned and then when I go back into the Custom
Filter dialogue I find that Excel has reset my value to be just 2.
In order to get round this I have tried putting the 02 inside quotes
but then all the rows are returned because a quote comes before a zero
in the sort sequence.
This seems as if it should be really simple, but I'm stuck. Any help
would be very appreciated.
Martin
I have a column, formatted as text, with the following:
Heading
02
01
05
04
03
(that's zero 1, zero 2 etc).
Ultimately I want to filter the values to show those greater then xx
and less than yy. However, for now I'm just trying to get the first
part to work.
I have tried using Custom filter :
If I enter Equals 02, all is well. However, if I specify Is greater
than 02, no rows are returned and then when I go back into the Custom
Filter dialogue I find that Excel has reset my value to be just 2.
In order to get round this I have tried putting the 02 inside quotes
but then all the rows are returned because a quote comes before a zero
in the sort sequence.
This seems as if it should be really simple, but I'm stuck. Any help
would be very appreciated.
Martin