10-17-2007 12:03 PM
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
10-17-2007 12:08 PM
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
10-17-2007 12:13 PM
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.
10-17-2007 12:30 PM
Hi,
if you are sending your data with OLE try something like this:
SET PROPERTY OF GS_CELL1 'NumberFormat' = '#,##0.000'.
Kostas
10-17-2007 12:48 PM
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
10-17-2007 1:52 PM
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
10-17-2007 1:56 PM
Hi,
have you tried what i mentioned?
In my code it works.
Regards, Dieter