I downloaded some reporting in XML format because it was the easiest.
Now i am trying to use the autofilter to custom filter dates however it
won't work!

For instance, i'm trying to custom filter by:

is less than or equal to 05/26/2006

----

However it just won't work.

Help?


--
jim_0068
------------------------------------------------------------------------
jim_0068's Profile: http://www.excelforum.com/member.php...o&userid=32822
View this thread: http://www.excelforum.com/showthread...hreadid=546057

Most likely your dates are seen as text, make sure they are numbers

to test

=ISNUMBER(A2)

where A2 is the first cell with the dates, copy down. If the results are
TRUE they are dates that Excel can understand

to make a text date turn into number date, format a cell as dates but leave
it blank, copy it,select the imported dates (the lot), then do edit>paste
special and select add

If that doesn't help then you have invisible characters in the cells


Regards,

Peo Sjoblom

"jim_0068" wrote:

>
> I downloaded some reporting in XML format because it was the easiest.
> Now i am trying to use the autofilter to custom filter dates however it
> won't work!
>
> For instance, i'm trying to custom filter by:
>
> is less than or equal to 05/26/2006
>
> ----
>
> However it just won't work.
>
> Help?
>
>
> --
> jim_0068
> ------------------------------------------------------------------------
> jim_0068's Profile: http://www.excelforum.com/member.php...o&userid=32822
> View this thread: http://www.excelforum.com/showthread...hreadid=546057
>
>

Your test comes up as "false."

So does that mean they are invisible texts?


--
jim_0068
------------------------------------------------------------------------
jim_0068's Profile: http://www.excelforum.com/member.php...o&userid=32822
View this thread: http://www.excelforum.com/showthread...hreadid=546057

Nevermind, i got your edit/paste idea to work.

Thanks a bunch!


--
jim_0068
------------------------------------------------------------------------
jim_0068's Profile: http://www.excelforum.com/member.php...o&userid=32822
View this thread: http://www.excelforum.com/showthread...hreadid=546057