Problem with date format

maze · Feb 23rd, 2002, 06:14 PM

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.

Anne Troy · Feb 23rd, 2002, 06:47 PM

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.

Feb 23rd, 2002, 06:47 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 23rd, 2002, 06:14 PM	#1
maze New Member Join Date: Feb 2002 Posts: 1	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.