BIP report RTF template excel output type date formatting issue

Summary:

Hi,

Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showing time also. Used 'mm/dd/yyyyy' in the data model and RTF column also set as 'mm/dd/yyyy'. But still when we click the date value in the excel showing as date and time on the header. Please share your inputs to show only date .

Content (please ensure you mask any confidential information):

Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showing time also. Used 'mm/dd/yyyyy' in the data model and RTF column also set as 'mm/dd/yyyy'. But still when we click the date value in the excel showing as date and time on the header. Please share your inputs to show only date .