Excel Download Problem- REUSE_ALV_HIERSEQ_LIST_DISPLAY

[Former Member]

Hi..

I am downloading output to excel by standard functionality. But There is one character field of length 20 ,

When I download it to EXCEL data gets converted into exponential format .

e.g. 3*********03 will be showing 3.00E+17. But when I check contents of cell it shows 3********00 in excel. It replaces last two characters to '0' directly.

Thanks

Ashish

[Former Member]

Hi Ashish,

I think so it is getting downloaded in the right manner. But the appearance in excel is different.

Please do the changes in your excel as below.

Right click on cell(Where ur getting wrong formatt )>Formatting cells> select category in Number Tab and choose your desired format

then click Ok.

Thanks,

Rakesh Vanamala.

Edited by: rvanamala on Feb 1, 2011 1:24 PM

[Former Member]

I alreay tried that option, But Issue is it replaces last two characters say they are '03' with '00'

[Former Member]

CHANGE THE CELL PROPERTIES OF EXCEL SHEET TO TEXT.

REGARDS

Niladri Mukherjee

[Former Member]

Thanks