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

My control panel settings are correct and the file properties show correct
date and time. Please copy responces to

Thanks,

David

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

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

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

"Niek Otten" wrote:

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

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

On Wed, 22 Jul 2009 13:00:01 -0700, David
wrote:

My control panel settings are correct and the file properties show correct
date and time. Please copy responces to

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