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 The date in a excel worksheet is wrong. =now() responds 1-0-1900

Format as a proper Date

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"David" wrote in message
...
My control panel settings are correct and the file properties show correct
date and time. Please copy responces to

Thanks,

David