Excel date formatted cell displays date entered as Jan-01-1900

D

Dermot

The cell is formatted for Date in any of the formats provided by Excel; but
any date entered is displayed as Jan-01-1900, 01-Jan-1900, 01-Jan-00 etc.
Thsi is a frequent problem that cannot be fixed clearing formats or by
re-formatting etc.

This is an annoying problem that wastes a lot of time in re-creating a new
spreadsheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top