Scientific Notation or Exponential Value while export/download to Excel from ALV

[Former Member]

Folks

Some of the values from a custom ALV output are downloaded in an exponential format or scientific notation while exporting to an excel file.

One value is okay on expanding the column but there is another field value of length more than 45 characters and it does not convert to correct value.

Please suggest me with a resolution. Thank you.

[Former Member]

Folks

Some of the values from a custom ALV output are downloaded in an exponential format or scientific notation while exporting to an excel file.

One value is okay on expanding the column but there is another field value of length more than 45 characters and it does not convert to correct value.

Please suggest me with a resolution. Thank you.

[Juwin]

This is a problem with Excel display. Excel considers it as a number because there are only numeric characters in that field. And there is a limitation in Excel on how big a number can be shown.

Please try to use newer methods to download data from SAP, and they will make the field as a String in Excel.

Thanks,

Juwin

[Former Member]

Yes, Could you please be (more) specific or list those newer methods to export ALV output onto Excel

Thank you

[Juwin]

Please search on SCN for those options and if you face any trouble while using them, kindly let us know.

Thanks,

Juwin