topic Re: ALV excel formatting in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-excel-formatting/m-p/8110013#M1617394 <HTML><HEAD></HEAD><BODY><P>You could create an internal table for the SALV that has all character fields. However, Excel might still interpret those as numbers. Why not have the user select the columns in Excel and format cells as text?</P></BODY></HTML> Thu, 18 Aug 2011 14:32:52 GMT Former Member 2011-08-18T14:32:52Z ALV excel formatting https://community.sap.com/t5/application-development-and-automation-discussions/alv-excel-formatting/m-p/8110012#M1617393 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>how to set in SALV some formatting in exporting to excel file.</P><P>I want to convert some numbers variables to text format before will be create XLS sheet.</P></BODY></HTML> Tue, 16 Aug 2011 14:44:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-excel-formatting/m-p/8110012#M1617393 Former Member 2011-08-16T14:44:05Z Re: ALV excel formatting https://community.sap.com/t5/application-development-and-automation-discussions/alv-excel-formatting/m-p/8110013#M1617394 <HTML><HEAD></HEAD><BODY><P>You could create an internal table for the SALV that has all character fields. However, Excel might still interpret those as numbers. Why not have the user select the columns in Excel and format cells as text?</P></BODY></HTML> Thu, 18 Aug 2011 14:32:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-excel-formatting/m-p/8110013#M1617394 Former Member 2011-08-18T14:32:52Z Re: ALV excel formatting https://community.sap.com/t5/application-development-and-automation-discussions/alv-excel-formatting/m-p/8110014#M1617395 <HTML><HEAD></HEAD><BODY><P>Better will be send to excel characters in text format not general format because user will must formatting this after every export to XLS.</P></BODY></HTML> Fri, 19 Aug 2011 08:52:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-excel-formatting/m-p/8110014#M1617395 Former Member 2011-08-19T08:52:36Z