Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Number format error

Former Member
0 Likes
866

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!

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
810

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

5 REPLIES 5
Read only

Former Member
0 Likes
811

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

Read only

Former Member
0 Likes
810

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

Read only

Former Member
0 Likes
810

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

Regards

Vinod

Read only

Former Member
0 Likes
810

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

Read only

andreas_mann3
Active Contributor
0 Likes
810

use a char-field and command:

translate itab-wrbtr using '.,'.

A.