Format With Leading Zeros

[Fun_Geek]

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

 

[Fun_Geek]

How would I proceed with the code? Assume pasting it somewhere into the VBE...

 

[daleyman]

yep. for either example, it is an event code that needs to be posted to the module relating to the worksheet that you require the functionality to appear on. Go into the VBE, double click sheet1, or whichever sheet, that will bring up the script page for that sheet. Then just paste it in there.