08-18-2015 7:02 AM
Hi,
Please tell me how to remove the leading zeros while downloading the alv output through spreadsheet option.
08-18-2015 4:27 PM
Hello Sneha, I've been searching for this feature too with no luck. These are my 2 workarounds:
1. with your ALV report open, select the menu options List > Export > Local File ... Text with tabs. Save the file and open it with Excel.
2. export to Excel and with the function VALUE transform the the text formated cells to numbers. Leding zeroes will disappear.
You might have some more luck if you place your question on the community for
Cheers,
Michael