Hi,
I would like the user to input the date, but in this format:
ddmmmyy

right now i have it through Data/Data validation and it works out, but it keeps the month first letter in upper case like:

01Mar13


I would like to have it like:

01mar13

Thanks!