How to format Excel Column

[Former Member]

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

Thanks in advance.

[Former Member]

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.

[Former Member]

Hi

Try this:

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

thanks,

Renjith

[Former Member]

Thankz