When I am exporting from a radGridView to Excel the dateTime format was not working. I used a snipit of code I had found in this forum to format the column in the Excel document.
col.ExcelExportType = DisplayFormatType.Custom;
col.ExcelExportFormatString = CultureInfo.CurrentCulture.DateTimeFormat.FullDateTimePattern;
This works for the most part but there is still an issue with the formatting. On my winform the date is displayed like
The Excel doc then displays it as:
09/01/2001 16:30 tt
How can I format this to show up in the same manner?