ALV to excel sheet

[Former Member]

Hello Gurus,

After ALV output I have to click on the button local file and select spredsheet and transfer the whole data to Excel sheet.

I am able to do that, but the problem is for an tracking number in the excel sheet is getting displayed as 2.09952E+13 instead of 20995150196137.

Please do tell me how to left justify this in the sheet.

<REMOVED BY MODERATOR>

Regards

Mac

Edited by: Alvaro Tejada Galindo on Apr 16, 2008 12:13 PM

[Former Member]

Expand the width of the column in EXCEL. You should be fine.

[Former Member]

Hi,

I know that if we expand that field it will show.

But still it doesn't show in here.

Is there any code needed to be done for that.

Regards

Madan.

[Former Member]

You can also change the Format of the column to Number with 0 Decimal positions. I tested this and it works.

I also put your value in Cell A1 and did this in A2

=CONCATENATE(A1)

and it showed up fine

Concatenate works because it converts the number to a string.

Edited by: Paul Chapman on Apr 16, 2008 6:22 PM

[Former Member]

Hi,

I even know this thing too sir.

I dont want to do any modifications in the excel sheet.

I want to do in the abap code.

Is that possible?

Regards

Mac

[Former Member]

What happens when you simply push the Excel button on the Tool Bar and then save that spreadsheet?

[Former Member]

please eneble the macros before downloading to your excel sheet