Not preserving time format while exporing to excel

Aug 9 2012 7:48 AM
Hi All ,

I tried to export XML data to excel using datasets which includes one column of 24 hr format time in my table .
Now when it is exported to excel it is displaying in 12 hr format .I want to preserve the 24 hr format.

Please suggest me the solution .

Answers (1)