Stop Excel from Formatting SAP Data

[former_member768607]

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.

[former_member768607]

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]

This is not a standard functionality, ask your ABAPer.

[Lakshmipathi]

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