T created a spreadsheet with a Date column and want the format to be 02/19/06
but I want to be able to type in the six digits without typing in the slashes.

Typing in today's date of 021906, you get 12/22/59, the 21,906th day of
(last) century.

Is these a way to format the cell to be able to type just 6 digits and get
the correct date?

Thanks

Hi Sandy,

As far as I know, you must type the slashes when entering dates.

If your just looking for an easy way to enter today's date, use Ctrl+; to
have Excel enter it for you. It will display in the date format you specified.

Regards,
GS


"Sandy" wrote:

T created a spreadsheet with a Date column and want the format to be 02/19/06
but I want to be able to type in the six digits without typing in the slashes.

Typing in today's date of 021906, you get 12/22/59, the 21,906th day of
(last) century.

Is these a way to format the cell to be able to type just 6 digits and get
the correct date?

Thanks

See http://www.cpearson.com/excel/datetimeentry.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sandy" wrote in message
...
T created a spreadsheet with a Date column and want the format
to be 02/19/06
but I want to be able to type in the six digits without typing
in the slashes.

Typing in today's date of 021906, you get 12/22/59, the
21,906th day of
(last) century.

Is these a way to format the cell to be able to type just 6
digits and get
the correct date?

Thanks

Another way is to use the addin at
http://xldynamic.com/source/xld.QDEDownload.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sandy" wrote in message
...
T created a spreadsheet with a Date column and want the format to be
02/19/06
but I want to be able to type in the six digits without typing in the
slashes.

Typing in today's date of 021906, you get 12/22/59, the 21,906th day of
(last) century.

Is these a way to format the cell to be able to type just 6 digits and get
the correct date?

Thanks