Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conversion of qty field in excel with decimals and commas

Hi Experts,

We have a report in which we are sending a mail as xls attachment to the sender.

In this we have qty field. But they get displayed without the thousand and decimal saperator. e.g 1234 where it should be 1,234.000.

Is there any way to do this. Will WRITE statement help.?

Its urgent.Kndly let me know as soon as possible.

Thanks in advance,

Rashmi.

Former Member
replied

Hi,

Yes, WRITE statement will work. While filling the amount & quantity fields of the excel sheet, don't just move, instead use WRITE statement.

WRITE : wa_outtab-netwr TO i_excel-netwr.

Regards

Bala Krishna

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question