Cuts off leading zeros in a report column when "Download to Excel" function


When a text column contains leading zeros for example "000250" the download to Excel stores the string as "250" in the spreadsheet. I am using a column which is a string.(varchar)
Can somebody suggest me , how to go ahead with it
Edited by: user647228 on Sep 11, 2008 1:40 PM
Edited by: user647228 on Sep 11, 2008 1:42 PM


(To Vins) Actually, concatenating a space doesn't do it. When the file is downloaded into Excel, the leading space is ignored and it the leading zeroes are still trimmed.
To user647228: A non-space character needs to be concatenated. Regarding what character to append, I would give the following consideration: If the users are content with seeing an added character to the "number," you can append say an underscore "_" and Excel will download the number properly. It's fairly unobtrusive and can be "visually ignored."
If the end user insists on gettin rid of the extra character once the file is downloaded, I would append a character that is rarely, if not never, used in the report. (This ensures or mitigates replacing other instances of the character.) Then you can do a Replace All in Excel to replace the extra character with a single apostrophe. The single apostrophe will be interpreted by Excel to mean "text" and the appearance will change to exactly what is desired.
Note: Replacing the extraneous character with a space for example, will result in the leading zeroes being again lopped off by Excel...

November 30, -0001

Cuts off leading zeros in a report column when "Download to Excel" function

Hello When a text column contains leading zeros for example "000250" the download to Excel stores the string as "250" in the spreadsheet. I am using a column which is a string.(varchar) Can somebody suggest me , how to go ahead with it

Download to Excel" function cuts off leading zeros in string

When a text column contains leading zeros for example "000250" the download to Excel stores the string as "250" in the spreadsheet I am unable to find a log about this thanks Muthanna1) Click on the fx button of the column in question.

Preserving leading spaces in a report column.

Hi I have a report region derived from a sql query. One of the columns in the database can contain leading spaces. However, my report column is not displaying the leading spaces. These are the things I've tried: On the Column Attributes page, under C

PO history report when downloaded in excel it truncates last digit of vendo

Hi, We have a customized report developed for PO history.When executed ,it displays the report.However when we transport that to excel spreadsheet,surprisingly the vendor number gets truncated at the last meaning the last digit of the vendor number d

Megge column when export to excel

User is requesting Excel column header to split for infoobjects that are displaying key & text. See attachment showing the column header splitting. (Currently all key & text headers merge when exported into Excel apart from last object in row.Hi,

Merge columns when exporting to excel data only

Hi, I have a report with headers in fowling format.          Quantity         | first day   |  last day | When exporting to excel data only I want output in following format and want to merge upper header cells. Quantity First Day Last Day Please rep

All the columns of an alv grid report are not downloading in excel in 1 lin

Hi All, I have some 60 columns in my alv grid report and user can download the report using list->export->localfile->spreadsheet. What the issue is that all the columns are not downloading in one line, instead they split in two rows. Please help.

Abap report error while downloading to excel.

Hello All, I have a abap report which displayes the output in frontend and I want to download it to the excel file. When i choose from menu bar the options like-- LIST-> MOVE ->Save to PC File.  some of the negative values get merged into one single

Cannot Maintain Columns when exporting to Excel

I am trying to export a device report from PDF to Excel however the columns all show up but the information is not placed accurately as to each column.You either need the Acrobat Forum or the ExportPDF Forum, where people who use the correct software

Remove leading zeros in report

Hi all, I do a clasical reoporting. Data in the internal table numeric types. But when writing in the report, is appearing as 000056 etc. I want to remove this leading zeros in the report output. Any helps? Regards, Mic.Hi Michael,      u can use the

ALV Leading ZERO issue

There is leading zeros in internal table passing to FM 'REUSE_ALV_GRID_DISPLAY' but i am not able to see the leading zero in alv report display. how fix this.hi check out have u added no_zero(1)     type c, in fieldcatalog. if yes than remove it. els

HP Prime - Suggestion: Leading zeros.

Hopefully this is an appropriate place for this post. One of the most annoying aspects of the Prime is the way it strips off leading zeros from numbers. This results in "0.791" being displayed as ".791". To my mind, this is ugly and, a

0material leading zeros in analyser

Hi, I want to hide 0material leading zeros in my reports. I'm using the Bex analyser and I didn't find any option in the query designer. It's maybe just a checkbox or something but i'm afraid it's not possible... Thank you for your answers. NicolasHe

Why is part of the page cut off in Adobe Muse 2014?

I installed Adobe Muse 2014 and experiencing a few issues. The Master pages are cut off at the bottom of Plan page. When I go into design, some of the toolbar is cut off & I can't access icons. When I go to page properties, the box opens up at the to

Drop Zone video is cut off

I started using DVD Studio today with a template that has a drop Zone it appears to be cut off on the bottom third now. When I reposition the drop zone size I notice the cut off area changes in size. After two years of using this program... this is a

Video Cut Off

I recently purchased a 3rd gen nano from a friend, when i add video's and movies it cuts off the sides of the videos. When playing a music video i cannot see the first 3 or four letters of each line (artist, song, album, etcetera). Any ideas?Computer

Why does it cut information when converting to Excel?

Why does it cut the info @ the bottom of the page when converting to Excel - last 6 lines after the negative amount (CLAIM-RFC) is included in the headings of the following page and not included into Excel.. 3723 30273723 769886 INVOICE 10/06/14 6,83

IR - Column with leading Zeros issue

Hello, I've got an IR report which includes as "default report settings" 1 column with leading 0s. In order to export to Excel that column as text rather than as a numeric I followed a workaround proposed before in this forum (excel copy drops l

Report Builder: output to Excel removes leading zeros

I'm trying to use the Report Builder to output a numeric field to EXCEL , but on numbers that start with zero EXCEL removes the leading zero's. ex. 00123 becomes 123. Is there something that I can put in the expression builder on the field to overcom

Group Headers Causing Crystal Report to be Cut Off

Hello, We're using Crystal Reports 2008 to create a report. Our problem is that when he add group headers and a subtotal, the report gets cut off on the right side inside of Crystal Enterprise. Inside of Crystal Reports 2008, it looks fine. It's just