Formatting Excel Fields thru ABAP

[Former Member]

I want the Excel Cell to hold value 002. But If we enter the values thru the Program, it just displays 2. Tell me how to retain zeroes on the left. Ex: Account No. 000123456789.

[Former Member]

just open xls sheet.

right click on coloumn.

click format cells

select text option.

click ok.

now u can insert 002.

[Former Member]

Hi Venkat,

You need to change the property of the column to text else Excel cuts the leading zeros..

U can set it to text in the format cell option..

No change is required from the program end..

Regards,

Tanveer.

Please mark if found helpful..

[Former Member]

Give File type as 'WK1' in GUI_DOWNLOAD