https://community.sap.com/t5/application-development-and-automation-discussions/issue-with-ole/m-p/5624589#M1280926 <HTML><HEAD></HEAD><BODY><P>Change the NumberFormat attributes of your cell. (syntax SET PROPERTY OF &lt;cell_object&gt; &lt;format_string&gt;) </P><P></P><P>Look for sample at [OLE concept for downloading the report output into excel|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=%2fwiki%2fsdn_wiki%2fwiki%2fdisplay%2fsi%2fole%2bconcept%2bfor%2bdownloading%2bthe%2breport%2boutput%2binto%2bexcel]</P><P></P><P>Regards</P></BODY></HTML> Mon, 04 May 2009 16:14:10 GMT RaymondGiuseppi 2009-05-04T16:14:10Z https://community.sap.com/t5/application-development-and-automation-discussions/issue-with-ole/m-p/5624588#M1280925 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using OLE concept in my program. When i am passing date as January 01, 2008 in output is converting and displaying as 01-Jan-08. In output i have to disaply January 01,2008.</P><P></P><P>Anybody can tell me how to fix it.</P><P></P><P>Thanks,</P><P>Maheedhar</P></BODY></HTML> Mon, 04 May 2009 14:57:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/issue-with-ole/m-p/5624588#M1280925 Former Member 2009-05-04T14:57:28Z https://community.sap.com/t5/application-development-and-automation-discussions/issue-with-ole/m-p/5624589#M1280926 <HTML><HEAD></HEAD><BODY><P>Change the NumberFormat attributes of your cell. (syntax SET PROPERTY OF &lt;cell_object&gt; &lt;format_string&gt;) </P><P></P><P>Look for sample at [OLE concept for downloading the report output into excel|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=%2fwiki%2fsdn_wiki%2fwiki%2fdisplay%2fsi%2fole%2bconcept%2bfor%2bdownloading%2bthe%2breport%2boutput%2binto%2bexcel]</P><P></P><P>Regards</P></BODY></HTML> Mon, 04 May 2009 16:14:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/issue-with-ole/m-p/5624589#M1280926 RaymondGiuseppi 2009-05-04T16:14:10Z https://community.sap.com/t5/application-development-and-automation-discussions/issue-with-ole/m-p/5624590#M1280927 <HTML><HEAD></HEAD><BODY><P>solved by own.</P></BODY></HTML> Tue, 23 Jun 2009 12:09:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/issue-with-ole/m-p/5624590#M1280927 Former Member 2009-06-23T12:09:19Z