problem while downloading data into excel

[Former Member]

Hi ABAPers,

Im using OLE to download entries from internal table to excel.

One of the entry in internal table is of length 18 i.e account no. = 123456789876543212,type c(18)

My problem is that when this entry get downloaded in excel it gets printed as exponent.

i.e1.23457E+17.

How can i print account no. in the same format.

please help.

thanks in advance.

regards,

Lokesh

[Former Member]

The data is getting dowonloaded properly.

Just open your Excel file, select the column and select menu Format=>Cells

Change Category to NUMBER and change DECIMALS PLACES to 0.

I think this will solve your problem.

regards,

Jinson

[Former Member]

Hi Jinson,

Thanks for your reply.

But i do not want to do it manually.i want it will automatically comes like that.

regards,

Lokesh

[Former Member]

Hi Lokesh,

The solution for your problem is that download the table in MHTML format which can be seen when you click Spreadsheet.Then open the MHTML file in Excel. The problem will be solved.

I think this problem is answered very late but still it will help others with this problem

Regards

Andrew