excel2003
what is purpose of asterisk in date format *3/2/07?
when i use advance filter, a line with a date in it formated with the
asterisk gets filtered out, even though the data in the line satisfies all
criteria and should not be filtered out.
why?