Hello everyone,

I have a cell for example A1 where a user enter the date value.
I want to specify the date format to be MM-DD-YYYY.
Also, if the user enters only YY(last 2 digits) for the year it should automatically format it to YYYY.
how can this be done? you help is really appreciated.

Thanks,