2010 Apr 06 9:25 AM
Hello,
I´m downloading an internal table to Excel, but the numeric fields are downloaded with next format 10554.28 . I need that the number will be shown as 10.554,28, in others words, change '.' by ','.
I´m using the GUI_DOWNLOAD function.
Any help?
Thanks!
2010 Apr 06 9:29 AM
this has nothing to do with gui_download its about excel settings but if you want in to be like that format . try to make that field a char field. plus assign the statement using write command .
Thanks
Nafran
2010 Apr 06 9:29 AM
this has nothing to do with gui_download its about excel settings but if you want in to be like that format . try to make that field a char field. plus assign the statement using write command .
Thanks
Nafran
2010 Apr 06 9:30 AM
Hi ,
Check onnce with below nativigation...
Go to initial screen menu>system>userprofile>Owndata>Click on defaults-->Select decimal notation according to your requirement.
Regards,
Venkat.
Edited by: venkata siva reddy on Apr 6, 2010 10:30 AM
2010 Apr 06 9:30 AM
Make the internal table field in char data type and convert the data in internal table as per the required format.
Regards
Vinod
2010 Apr 06 9:34 AM
Hi,
No canges needed to be done in program, It comes from default user setting. Whatever is maintained there, comes in the output as default.
System->user profile->own data--->defaults
Change decimal notation there.
After making changes first time logout and login again to see the changes in output
2010 Apr 06 9:54 AM
use a char-field and command:
translate itab-wrbtr using '.,'.
A.