topic Number format error in Application Development and Automation Discussions

Number format error

Former Member — Tue, 06 Apr 2010 08:25:24 GMT

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!

Re: Number format error

Former Member — Tue, 06 Apr 2010 08:29:26 GMT

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

Re: Number format error

Former Member — Tue, 06 Apr 2010 08:30:11 GMT

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

Re: Number format error

Former Member — Tue, 06 Apr 2010 08:30:57 GMT

Make the internal table field in char data type and convert the data in internal table as per the required format.

Regards

Vinod

Re: Number format error

Former Member — Tue, 06 Apr 2010 08:34:01 GMT

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

Re: Number format error

andreas_mann3 — Tue, 06 Apr 2010 08:54:05 GMT

use a char-field and command:

translate itab-wrbtr using '.,'.