G Guest Jul 7, 2005 #1 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
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
A Anne Troy Jul 7, 2005 #2 What are you entering into the cell? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
What are you entering into the cell? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
G Guest Jul 7, 2005 #3 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?
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?
R Ron Rosenfeld Jul 7, 2005 #4 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 Click to expand... 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
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 Click to expand... 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
