date in excel ?
Otherwise it will look for the string B3 and not the contents
="<=B3"
--
Regards,
Peo Sjoblom
"Daniel" wrote in message
...
Thanks all
but why using the & as in ="<="&B3
Daniel
"Peo Sjoblom" wrote:
You can use a workaround
="<="&TEXT(B3,"mm/dd/yy")
change the "mm/dd/yy" to whatever date format you are using, I used US
date
format in my example
I guess it is because these D and advanced filter functions don't pick up
that B3 is a date so they display the true value of the cell
--
Regards,
Peo Sjoblom
"Daniel" wrote in message
...
hi
when my B3 cell with date 4/05/2007, I don't know why the A3 cell
display
serial number
My A3 cell with formula ="<="&B3
Can you explain this?
Thanks
Daniel
|