problem with formatting cell to date format
 

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

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Del" schrieb im Newsbeitrag
...
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

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

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

On Tue, 7 Dec 2004 11:05:01 -0800, Del wrote:

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

Thank you very much Frank !

THE QDE VBA worked great!

I grant you a special wish ! LOL

Del


"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Del" schrieb im Newsbeitrag
...
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

Hi
thanks for this feedback. Much appreciated.



--
Regards
Frank Kabel
Frankfurt, Germany

"Del" schrieb im Newsbeitrag
...
Thank you very much Frank !

THE QDE VBA worked great!

I grant you a special wish ! LOL

Del


"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Del" schrieb im Newsbeitrag
...
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