A long time ago I used to use some kind of "Auto" sub routine to check the contents of a cell and automatically perform some kind of action. I believe this has changed in later versions of Excel. Anyway, I'd like to enter a date such as 060506 and have it automatically turn into a date format, ie: 06/05/06. Can 'custom' formats be used to accomplish this?
If not, what is currently used in Excel to automatically check the cell and perform the format change?
Thanks!
If not, what is currently used in Excel to automatically check the cell and perform the format change?
Thanks!