Hi
try using the addin for which I provided you with a link
--
Regards
Frank Kabel
Frankfurt, Germany
"Del" schrieb im Newsbeitrag
...
Thanks for your input. The reason I would enter the date as 111904
is that
it is much faster to enter the data using the numeric key pad. I
would think
that most people who enter higher volumes of data would NOT want to
be
entering the date as 11/19/04, unless you were getting paid by the
hour. HA
"Peo Sjoblom" wrote:
Why would you enter a date like 111904? To me that is 111 thousand
904.
You need to enter dates in excel so excel knows they are dates!
Thus you
need to use date delimiters like / or - etc or using VBA, thus
either
11/19/04
or go here and use Chip's macro
http://www.cpearson.com/excel/DateTimeEntry.htm
Regards,
Peo Sjoblom
"Del" wrote:
Hello,
I am having a weird problem trying to format a cell to the date
format
mm/dd/yy.
When I enter a date of 111904 it returns a formatted date of:
05/19/06
Can anyone help?
Thanks in advance!!!!
Del