View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rocky Rocky is offline
external usenet poster
 
Posts: 18
Default Custom AutoFilter

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.