Kavi;

Use the following on the menu:

Format | Cells

Then on the category tab choose "Date" or "Custom" to choose a format or
create your own.
Does it help ?

Mark Rosenkrantz.

More Excel ? www.rosenkrantz.nl or

----------------------------------------------------------------

"Kavi" wrote in message
...
Hi there,

I'm updating my excel sheet data from ASP. I've a date
field. After updating from Excel Sheet, the cell format
changes into a number( I thing dateserial number)
eventhough I formatted the cell to accept date.

I want to show the date in the excel sheet, I used CDate
also & my reginal seeting also correct.

Pls help me to sort this.

Regards.