I am downloading data from SAP to excel sheet using the WS_DOWNLOAD Function Module. The numeric data in not having leading zeros. if it is 0010 it is displaying 10 in the excel sheet . i need the leading zeros in the excel sheet. without manulally changing it to Text in the excel sheet .
Is there any way to do it .
check this link
This can be done by concatenating a single quotation to the field before downloading . I have done this before and worked fine.
You can refer this blog by Naimesh link:[http://help-abap.blogspot.com/2008/09/preserve-downloaded-data-formatting-in.html] for more details.