I would like to know how to do this too, if anybody is reading.
I am using iReport 5.6 and jasperreports 6.2.2
I know that in excell any cell that starts with a quote (') is handled as text. That is what I need to do.
Since I generate reports in both html, pdf and excel, I cannot just put the quote in the data.
Thanks for any suggestion around this