SAP for Higher Education and Research Discussions
Spark conversations about student engagement, research optimization, and administrative efficiency using SAP in higher education and research. Join in!
cancel
Showing results for 
Search instead for 
Did you mean: 

how to avoid leading zeros of alv output while downloading through spreadsheet

0 Kudos

Hi,

Please tell me how to remove the leading zeros while downloading the alv output through spreadsheet option.

1 REPLY 1

michael_hobbins
Active Participant
0 Kudos

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