Mailing data in Excel in text format.

[Former Member]

Hi all,

When FM SO_DOCUMENT_SEND_API1 mailing the data as an excel attachmet,the numbers 0.0000 becomes 0 but I want it as it is....Is it posssible???please help

Thanks

Rajeev

[Former Member]

Hi,

In excel, we can't get the output as 0.00 instead of 0.

Because the basic functionality of excel is to display 0.00 as 0 only.

Regards,

Jyothi.

[Former Member]

Hi,

I know it ........but the thing is that when we set the format of excel as text it becomes like that .........means 0.000 willbe 0.000.

Is there any functionality from the programer side or from the FM side so that we can push it into the excel as text.

Thanks

Rajeev

[sreeramkumar_madisetty]

Hi

In excel, we can't get the output as 0.00 instead of 0.

Because the basic functionality of excel is to display 0.00 as 0 only.

That's the limitation of Excel.

Regards,

Sreeram

[Former Member]

Hi,

The data transfered to excel cannot be got in the format 0.00.

You can add a ' before the number and it can be transfered to excel will contain the '0.00.

Whatever format you pass into excel, it ll automatically changes as its default with excel.

Regards,

Dhasarathy

[Former Member]

Hi,

How will we do it into an Internal Table????

Thanks

Rajeev

[Former Member]

Hi Rajeev,

Before using the FM, Loop through the internal table, concatenate ' with the value and then modify the internal table.

Regards,

Dhasarathy

[Former Member]

but by doing this its reflecting the ' into a seperate column.

[Former Member]

Use concatenate for the field, but get clarification on this before using.