Hi, I have a report wich has some percentages in it. Whit setting "net.sf.jasperreports.export.xls.formula" I managed to let excel calculate the percentage (e.g. SUM(B1/A1) ). Assume A1 is filled with 100 and B1 with 10; in excel I get 0.10 with the mentioned formula. Now I want to be able to set the format of the percentage cell to "0%". Excel will display this cell with the above example as "10%". Only, how can I set a parameter to force Excel to use format "0%" for the particular cells? I hope someone can help me out! Greetz, Daniel