Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Autofilter yields no results | Excel Discussion (Misc queries) | |||
Can I use more than two conditions in custom autofilter? | Excel Worksheet Functions | |||
Custom autofilter Bug In excel 2002 | Excel Discussion (Misc queries) | |||
custom autofilter does not work | Excel Discussion (Misc queries) | |||
Shortcut for Filter- Custom Autofilter | Excel Discussion (Misc queries) |