| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#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? "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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match and count words | Excel Worksheet Functions | |||
| Past date in column to change color | Excel Worksheet Functions | |||
| How to change date as general "200306" to date "06/2003" | Excel Discussion (Misc queries) | |||
| Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
