RE:[sap-dev] Removing preceeding zeros in Excel after when it is downloaded from a report using ALV grid
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by sudharshank on Jan 31 at 10:19 PM |  Mark as helpful |
Maintain a separate itab with the respective column as Char and pass the original data to this itab, just before downloading.
---------------Original Message---------------
From: Sheri Jesse
Sent: Friday, January 29, 2010 2:55 PM
Subject: Removing preceeding zeros in Excel after when it is downloaded from a report using ALV grid
> In Excel, highlight the column containing your leading zeros, click on Edit--Replace, enter "000000000000" in the FIND WHAT field and leave the REPLACE WITH field blank. Next, click on the REPLACE ALL button. This will remove all of the leading zero's in that particular column.
__.____._ ---------------Original Message---------------
From: Sheri Jesse
Sent: Friday, January 29, 2010 2:55 PM
Subject: Removing preceeding zeros in Excel after when it is downloaded from a report using ALV grid
> In Excel, highlight the column containing your leading zeros, click on Edit--Replace, enter "000000000000" in the FIND WHAT field and leave the REPLACE WITH field blank. Next, click on the REPLACE ALL button. This will remove all of the leading zero's in that particular column.
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
