I work with dates a lot and I wanted to be able to put in 22302 and have it show as 2/23/02, so I formatted it and it worked great. The next day I went in and did the same thing and after I formated it and typed in 22302 and hit enter it shows me 1/21/61, OK, I got my dashes but where in the world did those numbers come from, I really would love to be able to use this, what am I doing wrong. Please help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Problem with date format
- Thread starter maze
- Start date
Anne Troy
MrExcel MVP
- Joined
- Feb 18, 2002
- Messages
- 2,632
- Office Version
- 365
- Platform
- Windows
Dates in Excel are *designed* to be entered with slashes or dashes. Period.
You may have set some kind of cell format, but it won't be read as a date. You can certainly type just 2/2 and hit enter and it will read 2/2/2002 if you have formatted it to.
You may have set some kind of cell format, but it won't be read as a date. You can certainly type just 2/2 and hit enter and it will read 2/2/2002 if you have formatted it to.
Upvote
0
