number format in Excel

[Former Member]

Hi Experts,

After downloading the Excel file, the amount field is using the General format (meaning, there is no specific format). Some amounts have 2 decimals, while others have 1 or zero decimal.

I want that column to have a standard format which is categorized as number and has a decimal of two.

Points will be rewarded.

Message was edited by:

p328202

[Former Member]

Hi Experts,

After downloading the Excel file, the amount field is using the General format (meaning, there is no specific format). Some amounts have 2 decimals, while others have 1 or zero decimal.

I want that column to have a standard format which is categorized as number and has a decimal of two.

Points will be rewarded.

Message was edited by:

p328202

[Former Member]

ya

once u get all the values into the excell sheet select that column and go with the left alignment option and save the excell sheet....

It should work for you

~~Guduri

[Former Member]

ya

once u get all the values into the excell sheet select that column and go with the left alignment option and save the excell sheet....

It should work for you

~~Guduri

[Former Member]

Hi mariposa ,

Select the full column, click on format cells and set the category as Number with decimals 2.

This will solve your problem.

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

[Former Member]

Hi Srinivasa,

Can I apply that using ABAP codes?

Message was edited by:

p328202

[Former Member]

Hi,

use the gui_download fm with WK1 type as the code page wihile downloding to the excel .

it will be downloaded same as the sap format.

Thanks,

Srinu.