Download number as it is without converting to exponential format

[Former Member]

Hi Friends,

When downloading some character field value which consists of the numeric value using the function module WS_DOWNLOAD, the number value is converting to the exponential form (like 4.6E+09) which has to be 4600000000000. How do we get the number as it is when we download that data to Excel file.

Thanx and regards,

Ram

[former_member181962]

Just double click on the column in the excel sheet.

Regards,

Ravi

[Former Member]

Hi,

This may be happening because of excel cell format. you need to change your excel file cell format. If excel file format is ok then you can do one thing the field you are downloading will be in inernal table. convert that field into TYPE N field in into internal table & then download.

If helpful answer assign points.

I am sure this may solve your problem.

Ashven

[Former Member]

goto the excel sheet and click on the field...it will display the whole number...Excel has property to show as exponent if large number and when clicked shows whole number.

[manoj_joshi6]

I really can't understand why some guys answer the question, without understanding. A lot of posts have this issue and the best (worst) part is that some of those answers are also decalred as the "best answer" !!

For instance, in this case, it is obvious that one can change the formatting in the excel, to get the desired result. But, the whole point of this question is to get an answer about the possibility of the program doing it automatically. If not possible, the best answer should be that "The standard FM cannot do this" and then mention the workaround.