Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I enter date 082305 xl changes it to 5/4/25
I set the date format for the cell as: 8/23/05. When I enter date 82305, I
get 5/4/25. I've checked everything I can think of but I haven't a clue as to what is causing this. Thanks for all help, |
#2
|
|||
|
|||
"Monalisa18" wrote: I set the date format for the cell as: 8/23/05. When I enter date 82305, I get 5/4/25. I've checked everything I can think of but I haven't a clue as to what is causing this. Thanks for all help, Monalisa You will have to enter the slashes to get the correct date. Excel calculates date from the 1/1/1901 and this is given the reference 1. Type 8/23/05 and then format the date as a number - it gives you 38587. So Excel is giving you the date for 4th May 2125 Regards Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Can I automatically enter the current date or current time into a | New Users to Excel | |||
enter month end date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Can I enter a date without using the / or hyphen? | Excel Discussion (Misc queries) |