Conversion Issue

[Former Member]

Hi All,

Issue 1 :- User is uploading excel sheet with decimal value say 0.3 or .003 but while converting the excel file to SAP internal table it's being changed to whole number 3.0.I've checked SU3 settings and validated excel format of the cell by comparing my system. There were no difference found.

Issue 2 :-

User is extracting report , the ALV output shows proper data but when it is transferred to excel the values are being shortened with * as prefix. Example :- Currency in ALV output 6,43,567 will be shown as *3567 in excel sheet.

Could you please advice to resolve mentioned issue.

Thanks in advance!

[Sandra_Rossi]

What do you use to "convert excel file to SAP internal table" ?