Skip to Content
author's profile photo Former Member
Former Member

1000 separator in excel download

Hi friends,

Is it possible to use 1000 separator(Comma separator) for the currecny field during GUI download

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 08:23 AM

    Hi varsha,

    1. In a way, we cannot control this from abap coding.

    2. the reason is

    a) using gui_download, normally the file created

    is a text file by nature, which is delimited by tab,

    and excel can understand and open it.

    b) the text file (which is having extension .xls, but having text format), does not provide any additional formatting option

    such as bold, font size, italic, column width , colour etc.

    c) So what ever is shown in excel, is as per its

    default setting in excel. If we can do anything,

    we only can do in excel to change the display format.

    regards,

    amit m.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 07:12 AM

    Hi,

    use conversion methods for quantity fields.

    hope ur problem is solved.

    Regards

    Giridhar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 07:18 AM

    Hi varsha,

    YES , it's possible.

    DATA l_amount TYPE bsid-wrbtr VALUE '12345.80'.

    DATA l_char_amount(16).

    WRITE l_amount TO l_char_amount.

    WRITE :/ l_amount.

    WRITE :/ l_char_amount.

    check your defalut user paramters

    on the menu bar

    system >User profile > own data

    In that click on defaults and check Decimal notation

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 08:19 AM

    Hi friends .Thanks for the reply...bUt i want to display it in the EXCEL file by using GUI_Download (Ex :display like 6,000.00)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.