Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
By default, Excel often has problems with handling SAP text numbers
correctly. It will truncate, or round, or lots of other things. Things
you can try:
* Make the column wider. Sometimes this will let the number display
correctly
* Change the cell format. By default, numbers display as numbers.
Changing the format of the number field to display as text can sometimes
correct the problem.
* Create a blank worksheet and format the entire sheet to text. Copy
the downloaded sheet and "Paste Special" - Values only. Sometimes this
will also correct the problem.
This is a common problem with numbers that are text based (order &
document numbers, Material IDs) as well as date and time formats.
Good luck.
Rich
--
Richard L. Errington
email@removed
512.444.1807 Home
512.658.2086 Mobile
512.351.4525 Fax
RLErrington (AIM/Yahoo)
| | | ---------------Original Message---------------
From: muniyappanagaraj
Sent: Thursday, February 17, 2011 3:55 AM
Subject: Last digit in PO number not displaying
I have taken ebeln field from mseg table. in my report ebeln field is displaying correctly. But when I download report output to Excel, in Excel last digit in ebeln field is not displaying |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Most Popular White Papers
In the Spotlight  _.____.__ |
