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?

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?

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?

Thanks; I had a look, but trying to teach me quantum physics would
probably be easier!!

Worth a try anyway....


Gord Dibben wrote:

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?