Decimal places in excel

[Former Member]

Hi,

I am sending quantity field to excel with three decimal places but when I open the excel after generating it shows only two decimal places.How can i obtain this function with excel it should show only 3 decimal places with thousand seperator.

Regards,

Karthik.k

[Former Member]

in your excel file , go to that column in which quqntity appears.

select this column

right click on this

fomat cell > Number >scientific > decimal places ( select 3 here).

reward if useful

Amit Singla

[Former Member]

Hi,

If you want to have 3 decimals in excel sheet you need to change the properties of particular column in excel to 3 decimals. Even if you have 3 decimals in SAP but while transferring to excel it will take only 2 decimals.

Thanks,

Sriram Ponna.

[kostas_tsioubris]

Hi,

if you are sending your data with OLE try something like this:

 SET PROPERTY OF GS_CELL1 'NumberFormat' = '#,##0.000'.

Kostas

[Former Member]

Hi,

data: str type string.

• 1000 it the value, put it as you need.

data: str1 type string value '1000'.

concatenate '=FEST(' str1 ';3)' into str.

put str in the excel-cell.

Regards, Dieter

[Former Member]

Hi,

I am generating the excel file in background.I don't have any physical excel file at run time since i am sending via mail. How will I make 3 decimal places in excel for this case.

Can we use OLE in background also where i don't have physical excel file.

Regards,

Karthik.k

[Former Member]

Hi,

have you tried what i mentioned?

In my code it works.

Regards, Dieter