The date in a excel worksheet is wrong. =now() responds 1-0-1900

[David]

My control panel settings are correct and the file properties show correct
date and time. Please copy responces to (e-mail address removed)

Thanks,

David

 

[Niek Otten]

Format as a proper Date

 

[David]

The cell is formatted as a date and the response is still January 0, 1900

 

[Ron Rosenfeld]

My control panel settings are correct and the file properties show correct
date and time. Please copy responces to (e-mail address removed)

Thanks,

David

What does your statement really mean?

Where did you put =now() ?

Where is 1-0-1900 being displayed?

Please give full details.
--ron