Date time converted into int

Oct 3, 2013 at 5:51 AM
i read excel file but there is a problam in date time columns its displaying like int

how to get it right form help me

thank you
Developer
Oct 31, 2013 at 10:20 AM
Is it formatted as a date in the excel sheet?
Feb 20, 2014 at 3:55 AM
I am having the same problem. I have a column of only dates (formatted as Date) and once converted to a csv it shows an integer. It's the latest code. Is there any solution?

Thank You
Aug 27, 2014 at 1:29 PM
Edited Aug 27, 2014 at 1:29 PM
You can convert your Int to DateTime with : DateTime.FromOADate(45854)
Steven