Skip to Content
0
Aug 11, 2013 at 05:02 PM

Spool to Excel formatting

392 Views

Experts,

My report is writing output to spool. I have a field of type DFKKLOCKS-LOOBJ1 in spool output. When I download spool output to excel(using save to local file icon in SP01 Tcode) I see that value of LOOBJ1 column is not displayed as expected,

Value in LOOBJ1 Column in Spool output,

1000001350550000001000

1000001350550000002000

1000001350550000002000

Value in LOOBJ1 Column in Excel file,

1E+211E+211E+21

When I format these cells to display data in number format, I can see incorrect values as below,

100000135055000000000010000013505500000000001000001350550000000000

I am getting correct values only upon "Use Text Import Wizard" feature of Excel.

Is there a way we can display the value correctly in Excel so that users need not manually format data each time.

Thanks,

Aspire