Thread: date in excel ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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