Hello,
When I download data from SAP to file *xls with "text with tabs" it removes leading zeros (two zeros) for certain cells. Can some one explain why this happens?
For example:
A1 0019Z09999
A2 1120078 <- lacking those two leading zeros
Edit. Now I got it. It doesnt remove leading zeros when there are letters in that cell..
Last edited by palapeli; 05-09-2017 at 10:16 AM.
Excel always removes leading zeroes in text files.
Same goes with CSV files.
Perhaps export the data with a quote in front then Excel will interpret the data as text.
But as soon as you perform a calculation on that field the result will have zeroes removed again.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Perhaps this link could be of help?
https://support.office.com/en-us/art...f-5dfa51f85fe7
Alf
If you export a file as excel file in SAP using function module GUI_DOWNLOAD, actually it is downloading as a tab delimited format which you can open with Excel or a notepad. If you export as a plain text file, the leading zero will be maintained but if you open with Excel, the leading zero is not maintained because Excel has it own formatting. By default, Excel set a cell as ‘General’ and this formatting will remove any leading zero of a value.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
You can create a custom format that allows leading zeroes for numbers
Formatting cells would not change the values. However, it can be done by formula.Originally Posted by philaugust2004
Something like this:
Formula:
Please Login or Register to view this content.
v A B 1 0019Z09999 0019Z09999 2 1120078 0001120078
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
format with 0000 or as many zeroes as digits in the largest number will add leading zeroes
ie enter 56 in a cell and create custom format of 0000 and it becomes 0056
Excel has an easy solution now, to avoid automatic data conversion.
File >
Data >
Automatic data conversion >
Remove leading zeros (uncheck)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks