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

Excel file with currency value

Former Member

‎2011 Mar 17 2:16 PM

0 Likes
1,332

Hi,

While downloading data using FM 'SAP_CONVERT_TO_XLS_FORMAT' or 'GUI_DOWNLOAD' in EXCEL format , the currency field is getting rounded off. Could some one suggest me how to avoid this?

Regards,

Sakthi

Hi,

While downloading data using FM 'SAP_CONVERT_TO_XLS_FORMAT' or 'GUI_DOWNLOAD' in EXCEL format , the currency field is getting rounded off. Could some one suggest me how to avoid this?

Regards,

Sakthi

Reply
3 REPLIES 3
Read only

Former Member

‎2011 Mar 17 2:22 PM

0 Likes
789

Hi

Pass the value as hardcoded text, say if you have the amount as 124.34 then pass it as ="123.34". That should solve your problem.

Regards

Ranganath

Read only

Former Member

‎2011 Mar 18 4:50 AM

0 Likes
789

Hi

change your currency field into character type in your program.

then try, hope it will work

thanks

LG

Read only

Former Member

‎2011 Mar 18 6:40 AM

0 Likes
789

hi sakthi,

try this link

Regards

Rajashiva ramalingam