HAVE A COLUMN OF DATE PAYMENTS ARE DUE DATE CHANGES TO 01/00/1900
 

WHEN I ENTER A DATE AND CLICK TO THE NEXT CELL THE DATE CHANGES TO WHAT EVER
IT WANTS BUT USUALLY TO 01/00/1900

What are you entering into the cell?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"CK" wrote in message
...
WHEN I ENTER A DATE AND CLICK TO THE NEXT CELL THE DATE CHANGES TO WHAT
EVER
IT WANTS BUT USUALLY TO 01/00/1900

Format the cells that you are using specifically to a date format. Format
Cells - Category Date ... and choose one.

How are you entering the date into the cell?

"CK" wrote:

WHEN I ENTER A DATE AND CLICK TO THE NEXT CELL THE DATE CHANGES TO WHAT EVER
IT WANTS BUT USUALLY TO 01/00/1900

On Thu, 7 Jul 2005 10:22:02 -0700, "CK" wrote:

WHEN I ENTER A DATE AND CLICK TO THE NEXT CELL THE DATE CHANGES TO WHAT EVER
IT WANTS BUT USUALLY TO 01/00/1900

Exactly, (by that I mean every single keystroke) how are you entering your
date?

If you are preceding the date with an "=", that is expected behavior. Don't
use the "=" sign.

If you are not preceding the date with an "=", then check
Tools/Options/Transition and ensure that the Sheet options are DEselected.


--ron