Issue with OLE --

[Former Member]

Hi All,

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.

Anybody can tell me how to fix it.

Thanks,

Maheedhar

[Former Member]

Hi All,

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.

Anybody can tell me how to fix it.

Thanks,

Maheedhar

[RaymondGiuseppi]

Change the NumberFormat attributes of your cell. (syntax SET PROPERTY OF <cell_object> <format_string>)

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]

Regards

[Former Member]

solved by own.