Code Project

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Excel Cell formatting in Export to excel from datagrid

1 Posts 1 Posters 0 Views 1 Watching

P Offline
P Offline
Phanindra Kumar

wrote on last edited by

#1

Hi, I have a date and time column in my datagrid and the time in this column is displayed with AM/PM format (ex:"10/11/2006 1:17:25 PM"). But when i export to excel, this time is turned into 24-hour format (ex:"10/11/2006 13:17"). How can i maintain the same format in excel sheet also. Thanks in Advance

Phanindra...
1 Reply Last reply

0

Log in to reply