topic Re: Stop Excel from Formatting SAP Data in Application Development and Automation Discussions

Stop Excel from Formatting SAP Data

Former Member — Tue, 17 May 2016 16:59:02 GMT

Dear Experts,

I have a scenario where we are exporting the sales order data to excel by using the sales order output.

but when we send the data to the excel, excel round off the 0's.

for example:

in SAP

Order quantity 1,000

In Excel

Order quantity 1.

Excel rounds of the last 0's.

is there any function module or some program which can be called to stop this Excel formatting?

Thanks in advance.

Jelena_Perfiljeva — Tue, 17 May 2016 20:38:35 GMT

This is not a standard functionality, ask your ABAPer.

Lakshmipathi — Wed, 18 May 2016 11:58:09 GMT

Moved from SAP ERP Sales and Distribution (SAP SD) to ABAP Development