You could format the cell the way you want and use data|validation (in xl2003
menus) to restrict the entry to a date.

Then in B1, you could use a formula:
=if(a1="","",text(a1,"mmm"))

Be aware that data|validation is easily broken (copy|paste will crush it). But
it should work if the user is typing something.

ps. The user will be able to type the date the way they like and the formatting
will show it to you as you like.

Personally, I'd use an unambiguous format like: dd-mmm-yyyy



Panchi wrote:

How can I limit input of A1 to a specific date format i.e. dd.mm.yy

From cell A1, I would like to extract the month and display as mmm in cell A2

Thanks

--

Dave Peterson