LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Autofilter yields no results rjejyork Excel Discussion (Misc queries) 4 July 20th 06 09:10 PM
Can I use more than two conditions in custom autofilter? Chris M Excel Worksheet Functions 2 July 6th 06 08:17 PM
Custom autofilter Bug In excel 2002 Matthew D Excel Discussion (Misc queries) 0 February 14th 06 02:54 AM
custom autofilter does not work Max Excel Discussion (Misc queries) 2 January 13th 06 02:41 AM
Shortcut for Filter- Custom Autofilter Eileen Excel Discussion (Misc queries) 2 November 27th 04 01:09 PM


All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"