Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 21, 2010 at 12:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Bala Krishna

      Thanks a ton to evryone who contributed to this thread.

      My query is resolved..

      Write statement helped..

      Had to build little logic though....but now it is workng...

      Thanks once again.

  • Jun 22, 2010 at 08:21 AM

    In fact that should be easily handled by the Excel. You only need to assign the right Excel type/ display pattern for that field in Excel. How do you create the Excel? OLE? XML?

    Otto

    Add comment
    10|10000 characters needed characters exceeded