Date entry
 

Is there a way to enter just the numbers 032107 and have it display the date
03/21/07?

Date entry
 

It's kind of complicated:

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

Biff

"excel-duh?" wrote in message
...
Is there a way to enter just the numbers 032107 and have it display the
date
03/21/07?

Date entry
 

There is a free Excel addin that does this,
http://www.xldynamic.com/source/xld.QDEDownload.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"excel-duh?" wrote in message
...
Is there a way to enter just the numbers 032107 and have it display the
date
03/21/07?

Date entry
 

To T. Valko and Bob Phillips. Thank you for your quick assistance. This newby
to Excel and this Discussion site appreciates the help offered by veterans
like you.
"T. Valko" wrote:

It's kind of complicated:

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

Biff

"excel-duh?" wrote in message
...
Is there a way to enter just the numbers 032107 and have it display the
date
03/21/07?