The format specifier 'tt' in the ExcelExportFormatString property should be outputed as 'AM' or 'PM'. For the formatting to work correctly the users have to set the property to Excel format codes not .NET format strings. Here is the list of excel's format codes: http://office.microsoft.com/en-us/excel-help/number-format-codes-HP005198679.aspx