09-08-2009 6:13 AM
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
09-08-2009 6:36 AM
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
09-08-2009 6:24 AM
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.
09-08-2009 6:31 AM
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
09-08-2009 6:27 AM
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
09-08-2009 6:36 AM
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
09-08-2009 6:58 AM
09-08-2009 7:07 AM
Hi Rajeev,
Before using the FM, Loop through the internal table, concatenate ' with the value and then modify the internal table.
Regards,
Dhasarathy
09-08-2009 7:09 AM
09-08-2009 7:05 AM
Use concatenate for the field, but get clarification on this before using.