Skip to Content
0
Former Member
Feb 16, 2011 at 05:26 AM

ALV export to Excel 2007 - Fields not as Text Format

773 Views

<H5>

Dears,

On ALV Report , once i save as Local file --> Spread sheets , Text Fields are saving as General. The problems which i face are

- Truncating leading Zeros in Text Field -- ie in ALV its showing as 000003 but in excel its showing as 3

- In AlV Character Field 123456789 but in Excel its showing as 1.23E+08.

My system is SAP_BASIS 701 LEVEL 0006, SUPPORT PACKAGE SAPKB70106.

I am using Excel 2007 and 2010.

Kindly help me in how i can fix this issue.

Best Regards,

Praveen Prasad R

</h3>