topic Re: How to format Excel Column in Application Development and Automation Discussions

How to format Excel Column

Former Member — Wed, 14 Oct 2009 09:25:03 GMT

I want to format excel column from "General" to "Text". Can anyone help me out in this regard.

Thanks in advance.

Re: How to format Excel Column

Former Member — Wed, 14 Oct 2009 09:27:49 GMT

Append a apostrphe ( ' ) to the internal table value if you are downloading it to an excel file. Those will be considered as 'Text ' field instead of a general field by the excel.

Re: How to format Excel Column

Former Member — Wed, 14 Oct 2009 09:47:03 GMT

Try this:

CONCATENATE '=REPLACE("",1,,"' l_field '")' INTO chars_field. And use chars_field for exporting to excel

thanks,

Renjith

Re: How to format Excel Column

Former Member — Wed, 15 Sep 2010 10:57:30 GMT

Thankz