Custom AutoFilter
Thanks Marcelo. I was bit confused.
Regards
Rocky
"Marcelo" wrote:
Hi Rocky,
the number 0,0173611111111111 is related to 00:25:00 in a general format,
so, you do not need to select 0:25 again.
hth
regards from Brazil
Marcelo
"Rocky" escreveu:
Suppose I have the following entries in a column:
0:20
0:21
0:22
.
.
.
0:30
Now I put a filter and select Custom. In the Customer Autofilter dialog box
if iselect "is less than and select 0:25" and click 'Ok', I get the correct
values. Now when I select Custom once again what is see is "is less than
0.0173611111111111" instead of "is less than 0:25". I have to select 0:25
once again in the drop down. This is very annoying. How can I solve this. Any
help is highly appreciated.
|