Excel Style help

[anujzcool]

Hi,

I am putting my values from UI to excel, now all these values are inserted as string values in the excel, But one of my columns has a date value in it.
It works fine till this moment but after doing this i apply Style in my cells in which i am just changing the colour and font.
However as soon as i apply style integer values are displayed in my cells containing date values.

Can anybody help me in what can be done here

Thanks and regards

[balabaster]

Hi,

I am putting my values from UI to excel, now all these values are inserted as string values in the excel, But one of my columns has a date value in it.
It works fine till this moment but after doing this i apply Style in my cells in which i am just changing the colour and font.
However as soon as i apply style integer values are displayed in my cells containing date values.

Can anybody help me in what can be done here

Thanks and regards

Change the cell format back to date. This isn't really a .NET question and should be under a different forum.

[anujzcool]

Thanks for reply

However since i have a dynamic column i wont be able to figure out which is the cell whose format need to be changed to date format.
Can you please suggest me some other way.