problem with formatting cell to date format

[Del]

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

 

[Peo Sjoblom]

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]

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

 

[Frank Kabel]

Hi
you can't enter date values this way. You need VBA for this. See:
http://www.xldynamic.com/source/xld.QDEDownload.html

 

[Frank Kabel]

Hi
try using the addin for which I provided you with a link

 

[Gord Dibben]

Del

Excel stores dates as a number with 1 being January 1, 1900

Each successive day since adds one to the number.

Today is December 7, 2004 and the number is 38328

111904 is May 19, 2206

Gord Dibben Excel MVP

 

[Del]

Thank you very much Frank !

THE QDE VBA worked great!

I grant you a special wish ! LOL

Del

 

[Frank Kabel]

Hi
thanks for this feedback. Much appreciated.