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

Amount getting changed to month automatically while downloading

Hi,

While i am downloading data to Excel sheet (For customer HU) some of the amount values are automatically getting changed to month and year. Eg : 54.07 getting changed to July 54. This seems a normal excel property. If we put 04-2008 in English US version of excel this will automatically get changed to Apr-08. Kindly let me know is there any way to overcome this issue by using some ABAP techniq or changing some settings in the Excel sheet.

Thanks in advance

Jijeesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 06:55 AM

    Hi

    In the excel sheet right click on the tab and then select Format cells and then select category as General.

    Hi Please enter convert_* in se37 and press f4 to check available FM which can help in this regard in the program.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 09:30 AM

    Hi,

    Can you check once in the program where the amount field is getting populated. Is there any conversion on that filed to date.

    some where depends on conditon it is getting converting to date format.

    Hope this will help you.

    Regards

    Tirumala Reddy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 24, 2008 at 05:21 AM

    Hi Jijeesh,

    It is not a program probelm.As VIshwa said it is excel sheet problem.To solve this goto mneubar Format->Cells->There in number tab set that as General.

    Hope this will help you.

    Thanks and regards,

    Narendra.Soma

    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.