Move a numeric field to Excel.

[Former Member]

Hi,

While trying to move a field containing only numbers, should the field contain leading zeros, Excel automatically removes them and stores it as a number.

Could anyone tell me the solution as to what i have to do in SAP before the GUI download?

Points will be awarded to the accurate solution.

Thanks,

Prem.

[Former Member]

Hi,

While trying to move a field containing only numbers, should the field contain leading zeros, Excel automatically removes them and stores it as a number.

Could anyone tell me the solution as to what i have to do in SAP before the GUI download?

Points will be awarded to the accurate solution.

Thanks,

Prem.

[Former Member]

Use

shift <variable> left deleting leading '0'.

Or

conversion_exit_alpha_output

[Former Member]

Hi SN,

I am sorry. But i forgot to mention that i want to preserve the field length and leading zeros in excel.

Could you please help?

[Former Member]

Apparently is not possible. There is no FM that changes the attributes of the cells.

What you could do is place a symbol before the number, like *000001 and the zeros would be intact

[Former Member]

That is exactly what i have done. But should there be thirty or forty fields, wouldnt this solution be highly time consuming?

If you have any docs about the same not being possible, could you send them across please? I would really to confirm before i use this solution.

Thanks a lot for your quick reply.