Data changes while exporting table into excel file in SAP

[Former Member]

Hi All,

We have very wiered situation as mentioned below.

While exporting the table into excel file the data gets  changed.

for eg if ean code is 871715494100083383 then will downloading into excel the data gets changed to 871715494100083000.

Only the last 3 digits of data gets changed to 0.

Has any faced the same issue before ?

Thanks in Advance,

With Regards,

Haresh Lathia

[former_member213851]

Hi Haresh,

You are using BDC or downloading from ALV download functionality?

[Former Member]

maybe we should have another forum, named like "OMG I have to deal with Excel."  If you want it handled as text, put quotes around it, or a ' on the front of the number.  Excel, in its inherent MS-installed brilliance, is converting based on what it is coded to do, which is guess at what the correct format should be.  Better yet, IMHO, put the output into a compressed, tab-delimited file named like .txt and let the user import it and do what they want.

[SuhaSaha]

Break Point wrote:

 Better yet, IMHO, put the output into a compressed, tab-delimited file named like .txt and let the user import it and do what they want.

That's exactly what i propose when someone asks me to import an excel in SAP

[Former Member]

Absolutely...my tiny pea-brain doesn't want to deal with... what?  MS Binary ?? or Open XML??   either....but a tab-delimited text file, we can do ANYTHING (just about) with that....

in or out, apps server or desktop, tab-delimited is the way to operate.

[Former Member]

Hi Haresh,

As per excel behaviour if you enter more than 15 digits in a cell which is formatted to have number it would change the digits after 15th to zero. This is due to some flaoting point number calculation specification used by Excel. Work around is to format the target cell as Text.

HTH