See Chip Pearson's site for event code that makes the changes as you enter the
digits without separators.

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

Excel does have any method of formatting without code as Chip presents.

You could enter dates as you wish then use a helper cell with a formula to
convert to real dates but not worth the extra work IMO.


Gord Dibben MS Excel MVP

On 5 Dec 2006 14:06:24 -0800, "Brainfire" wrote:

Probably either very simple or impossible... Is there any way to get
excel to enter a date in the format xx/xx/xxx by just typing in six
numerals? e.g. typing 11062006 would show as 11/06/2006?