Excel file attachment withiout losing leading zeros

[Former Member]

Hi Expert,

Can anybody tell me how to create the Excel file attachment for email generation without losing the leading zeros.

Regards,

Jyotsna

[Former Member]

Add apostrophe at the starting of the field to make the excel consider the field as a Text

[Former Member]

thankx 4 reply.

i got this but it take value like '0123456

so i want to remove special character(apostrophe).

Thanks,

Jyotsna

[Former Member]

In the excel, the apostrophe wont be displayed. It just indicates that the field should be cosidered as a text by the excel. Is the apostrophe being displayed in the excel attachement?

Vikranth

[OttoGold]

Hello,

you can use this approach: /people/otto.gold/blog/2010/02/11/happy-reporting-with-excel-ii

Regards Otto

[Rocky1]

Hi,

If you want to pass a variable with leading zeros to excel sheet, please use the following:

CONCATENATE '=TEXT(' l_variable ',"000")' INTO g_errcode1.

It will display the leading zeros in excel sheet. I have done the same way in one of my program and it is working fine..

Thanks & Regards

Rocky Agarwal