Hi guys,

I need to restrict entry of data in a particular cell. It must be in a "dd-mmm" format. But the catch is that it can't be in date format. It has to be only in text format. I need it in text format only, to be able to upload it to a custom software my office uses. The problem is whenever I enter "26-JUN" Excel automatically converts it to a date format.

So to sum it up I need to be able to restrict entry of data in a cell to [number][number]-[char][char][char] without automatically converting it into a date format.

Thank you.