Simplified Date Entry?

  • Thread starter Thread starter Brainfire
  • Start date Start date
B

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?
 
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
 
If you don't use date for calculation, then try this:
Format cells as
00\/00\/0000 (back slash and forward slash)
 
Thanks; I had a look, but trying to teach me quantum physics would
probably be easier!!

Worth a try anyway....
 
Back
Top