date in excel ?
Hi Daniel,
Use
="<="&TEXT(B3,"mm/dd/yyyy")
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"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
|