Ms Excel-2007 date formate.

you can do this first type date any format then right click on cell->format cells->select custom on number tab->then type in textbox dd/mmm/yyyy date format->ok.

Note:this way is use to define any format which you want,