Ok, it is because short date usually only contains digits, and you choose dd/MMM/yy If you go to additional setting and chnage to dd/MM/yy it will work
and I will see if I can take this Jan... Dec into account
Ok, it is because short date usually only contains digits, and you choose dd/MMM/yy
If you go to additional setting and chnage to dd/MM/yy it will work
and I will see if I can take this Jan... Dec into account