On Thu, 11 Apr 2013 22:58:07 +0000, AmitojC
wrote:


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!


12 IF mmm = "Jan" then d,"jan",yyyy
etc for each month

type swapout statements.