Does Custom Autofiltering dates work in XML Lists?

[jim_0068]

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

 

[Guest]

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]

Your test comes up as "false."

So does that mean they are invisible texts?

 

[jim_0068]

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

Thanks a bunch!