Hi Vijaya

Select the column, right click on the columnFormatCellsNumberCustom
dd-mmm-yyOK

--
Regards
Roger Govier

"Vijaya" wrote in message
...
Hi,
i have cerated one application with excel, there is column DATE so now my
qustion is how can i give condition to entair column for enter date end
user
as 14-May-09