I just verified on my home PC which hasn't been updated in a few weeks that
it doesn't work. Gord, you are right. I wasn't sure becuase they did a push
last night on my PC with some updates and didn't want to say something wrong
unless I proved it on my home PC.

"Gord Dibben" wrote:

All versions of Excel have never allowed nor recognized dates being entered
without a separator of some sort.

.. or / or -

"She" is incorrect when she says she did it yesterday.

To quick enter dates as 061908 to get June 19, 2008 you must use VBA code or
a helper cell with a formula.

See Chip Pearson's site for quickentry code.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Fri, 20 Jun 2008 10:36:00 -0700, Majikwoman
wrote:

No the she was able to enter the date yesterday in that format and it would
work. But today that format does not work. No updates were done ... it is a
mystery to me as to why it would work one day and not the next. I am at a
loss.

"Joel" wrote:

I tried a lot of different dates and they all work the same way. Are you
implying when you said "that it would of worked yesterday" that a update was
performed to excel to stop it from working, or do you mean if you put
yesterdays date (061908) that it would work. I tried 061908 and it does the
same thing.

"Majikwoman" wrote:

But there is an error in your theory ... entering this date yesterday would
have worked. That is what I don't understand. It does the same thing in
2003 and 2007. You idea is great but why did it work before

"Joel" wrote:

I know the answer. The date that show is 10/7/2069, the same thing happens
on my PC. When you enter 062008 ity is being entered as the number 62008 and
converted to a date format. 62008 is the number of days from Jan 1, 1900 to
10/7/2069.

Excel stores a date as a number. the number 1 = Jan 1, 1900. Each day is
counted as the number 1. Each hour is counted as 1/24 (1 day divided by 24
hours). Each minute is 1/(24*60).

Excel doesn't recognize 062008 as a date format, instead it thinks it is a
number. Because you have the cell formated as a date it converts the entry
into a date.

"Majikwoman" wrote:

Our user community is having trouble with formatting a cell to use the short
date. If they format the date to be for instance 06/20/08 and then type in
062008 a completely off the wall date appears such as 10/12/69. Is anyone
else experiencing this issue or does anyone have a fix for this? Please help.