Hi Vijaya
Select the column, right click on the column>Format>Cells>Number>Custom>
dd-mmm-yy>OK
--
Regards
Roger Govier
"Vijaya" <Vijaya.TakeThisOut@discussions.microsoft.com> wrote in message
news:5EBD2467-3E3B-4CA7-92A9-60AEB0C2049B@microsoft.com...
> 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