Thread: Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kavi[_2_] Kavi[_2_] is offline
external usenet poster
 
Posts: 2
Default Date Format

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.