Community
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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Export from ALV to Excel - problem with numeric values

Former Member

‎2004 Aug 27 9:43 AM

0 Likes
755

hi folks,

when exporting from alv to excel and we have negative values (and using an u.s.a. setting where . and , are different to r/3) negetive values are not shown correctly in excel.

when changing in win nt the regional settings to europe one's (e.g. germany) everything works fine.

any hints welcome,

kind regards

oliver

hi folks,

when exporting from alv to excel and we have negative values (and using an u.s.a. setting where . and , are different to r/3) negetive values are not shown correctly in excel.

when changing in win nt the regional settings to europe one's (e.g. germany) everything works fine.

any hints welcome,

kind regards

oliver

Reply
2 REPLIES 2
Read only

Former Member

‎2004 Aug 27 12:41 PM

0 Likes
626

I guess this has something to do with the excel settings. In the control panel you have regional settings.try some options there. It might work.

Regards

Sudhi

Read only

nablan_umar
Product and Topic Expert
Product and Topic Expert

‎2004 Aug 27 3:49 PM

0 Likes
626

In your ALV, do you see the negative sign in front or after the number?