1262820 - Cell format for a date in MS Excel displays as 'custom' for report exported to MS Excel from Crystal Reports

A report exported to the MS Excel format from Crystal Reports containing date values, displays the date properly within the MS Excel Spreadsheet.
Date cell format in the MS Excel spreadsheet displays as custom format and not the date format, why?

Crystal Reports 2008 V0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

CR, xls, export, date format , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.