If you don't use date for calculation, then try this:
Format cells as
00\/00\/0000 (back slash and forward slash)

"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?