Setting and existing Colum as a date

[Gordon Hooton]

Have tried a number of ways to set a existing column of dates i.e "24/3/2012" "dd/mm/yyyy" from text to date format.

Tried code such as

matchedsheet.Columns[0].CellStyle.NumberFormat = "dd/mm/yyyy hh:mm:ss";  and
matchedsheet.Columns[0].CellStyle.NumberFormat = "*dd/mm/yyyy hh:mm:ss"  and range.CellStyle.NumberFormatIndex = 14; and
range.CellStyle.NumberFormatIndex = "D4";

all to no avail.
The column has a heading "Process Date' all other entries are like "24/3/2012"

Has anyone any thoughts on how to force an existing column to be formatted as date, or as a number ?

Thanks and regards

 

[Gordon Hooton]

Just to correct the heading of this post

[Manikandan M]

Hi Gordon,

Thanks for using Syncfusion products.

We are afraid that we are able to reproduce the issue "Numberformat is not set to already existing cell with datatime as value and text type as format". We have created the simplified sample to reproduce the issue and have attached the same in the below link.

Sample link:106358_Forum.zip

Reference runnable video:Forum106358Video.zip

If the above attached sample does not meet with your sample scenario, please modify the sample and revert back to us. So that we can proceed further on this issue.

Thank you very much for your patience.

Please let us know if you need any clarifications.

Thanks,
Manikandan.M