Simplified Date Entry?

[Brainfire]

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?

 

[Gord Dibben]

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

 

[Guest]

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

 

[Brainfire]

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

Worth a try anyway....