Truncation of leading Zeros when Down Loading into Excel - OLE Objects

Hi,

Can any one help me on this.

I am using <b>OLE Objects</b> to download Data into Excel Sheet. Data with leading Zeros is getting truncated in Excel.

Ex: Report Output is showing Plant Number as 0002. But when i am downloading to Excel Plant value will become 2 .

I would like to have it as 0002 in Excel.

I have declared Werks as CHAR of 4.I am using OLE Obects for Downloading into Excel Sheet.

I am using "OLE2_OBJECT" I can not use any other FMs to down load to Excel.As i am modifying this program not creating.

Thanks In Advance.

K.Nirmala

Message was edited by: Nirmala Reddy