The User will enter a 8 digit date into a cell WITHOUT "/" separators, i.e., 01152002, representing January 15, 2002.
I would like the date displayed the same (01152002). It should not require the user to lead entry with apost (').
Also, another requirement is to validate date code on entry. It must be a valid calendar date (not something like January 34, 2002).
TIA
Mike
I would like the date displayed the same (01152002). It should not require the user to lead entry with apost (').
Also, another requirement is to validate date code on entry. It must be a valid calendar date (not something like January 34, 2002).
TIA
Mike