Another option is this Add-in
http://www.rondebruin.nl/qde.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
No built-in Excel feature.

See Chip Pearson's site for event code to make the change as you enter the
091006

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


Gord Dibben MS Excel MVP

On Tue, 26 Sep 2006 11:45:03 -0700, SDoyle@CAInc
wrote:

Is there a way (by formatting or functions) to type a date into a cell with
no slashes and then it will be formatted with slashes?

For example...If I want to type into a cell the date for Sept 10th 2006 and
i type 091006 is there a way for it to format in the cell with the slashes.
If I format the cell with a date format (and slashes) and I type into the
cell 091006, I get back 02/28/49. Is there a feature available to be able to
type the literal date into the cell without the slashes and receive that date
in the cell with slashes? I understand the 1900 date formatting but I wasn't
sure if there is a work around.