Ms Excel-2007 date formate.

Question

i want to date formate in ms excel 2007 like 25/feb/2009 it's possible.i try but always come this formate 25-feb-2009. please helpit's urgent.

Lalit M · Answer

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

Geeta · Answer

thanks lotgot it.