https://communities.sas.com/t5/SAS-Procedures/Proc-Report-putting-date-into-excel/m-p/409875#M67232 <P>I am using PROC REPORT to generate an xls file using the ExcelXP tagset.&nbsp; When I open the .xls file via Excel version 2010, the date appears as a date, but Excel does not recognize&nbsp;the data as a date.&nbsp; How can I pass the date format to excel. I have tried multiple styles and formats and have been unable get&nbsp;Excel to see the cell as a date.&nbsp; I would like to be able to use sort and filter functions in Excel on the date field, but I am unable to.&nbsp;</P> Thu, 02 Nov 2017 15:33:19 GMT dwknepper 2017-11-02T15:33:19Z https://communities.sas.com/t5/SAS-Procedures/Proc-Report-putting-date-into-excel/m-p/409875#M67232 <P>I am using PROC REPORT to generate an xls file using the ExcelXP tagset.&nbsp; When I open the .xls file via Excel version 2010, the date appears as a date, but Excel does not recognize&nbsp;the data as a date.&nbsp; How can I pass the date format to excel. I have tried multiple styles and formats and have been unable get&nbsp;Excel to see the cell as a date.&nbsp; I would like to be able to use sort and filter functions in Excel on the date field, but I am unable to.&nbsp;</P> Thu, 02 Nov 2017 15:33:19 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Report-putting-date-into-excel/m-p/409875#M67232 dwknepper 2017-11-02T15:33:19Z https://communities.sas.com/t5/SAS-Procedures/Proc-Report-putting-date-into-excel/m-p/409931#M67234 <P>You can put in specific code to set the format:</P> <P><A href="https://communities.sas.com/t5/Integration-with-Microsoft/Format-Excel-date-as-dd-mm-yyyy/td-p/194957" target="_blank">https://communities.sas.com/t5/Integration-with-Microsoft/Format-Excel-date-as-dd-mm-yyyy/td-p/194957</A></P> <P>&nbsp;</P> Thu, 02 Nov 2017 17:03:48 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Report-putting-date-into-excel/m-p/409931#M67234 RW9 2017-11-02T17:03:48Z