09-23-2008 7:48 AM
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
09-23-2008 7: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.
09-23-2008 7: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.
09-23-2008 10: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
09-24-2008 6: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
09-24-2008 6:27 AM
Hi..
Hope problem is solved.
Edited by: vishwa sri hari on Sep 24, 2008 7:27 AM