Decimal notation problem when downloading

[Former Member]

Hi,

I hava report wich downloads the data to excel file. The decimal notation for data is for gemna. ( COmma instead of dot and dot instead of comma). I have changed in user profile also. But when downloading to excel its downloading in default decimal notation. which is opposite format.

This should be for all quantity fields

Thanks

Kishore B A

[Former Member]

Hi Kishore,

Use the String / Char variable in your final internal table which you are downloading to excel sheet. Then use WRITE statement to output the quantity field into this variable.

e.g.

WRITE g_quantity to g_string LEFT JUTIFIED.

This will automaticaly convert the quantity to the user format.

Regards,

Vikas.

[Former Member]

Hi Kishore,

Let me tell you the solution.

Change the declaration of the final table field name to Char(10). It will automatically show you the correct format in the output.

Thanks,

Chidanand

[VikasB]

Hi Kishore,

Use the String / Char variable in your final internal table which you are downloading to excel sheet. Then use WRITE statement to output the quantity field into this variable.

e.g.

WRITE g_quantity to g_string LEFT JUTIFIED.

This will automaticaly convert the quantity to the user format.

Regards,

Vikas.