We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

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:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Sheri Jesse
on Jan 29 at 2:51 PM 		Mark this reply as helpfulMark as helpful
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: NavSen
Sent: Wednesday, October 07, 2009 5:05 PM
Subject: Removing preceeding zeros in Excel after when it is downloaded from a report using ALV grid

> Hi,<br/>I hope someone could help me with this issue. We have upgraded our ERP system to support Stack to level 15. After the upgrade when we download a report to excel file one of the fields is getting populated with leading zeros. When I ran the report, the report is showing for example 123456, once downloaded to excel it showing 000000000000123456. Is there a way to truncate those leading to what the report is showing after downloading it to Excel.
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language