Skip to Content
0
Former Member
Aug 15, 2016 at 02:18 AM

Export excel percentage values multiplied by 100

279 Views

Hi all,

I'm trying to export to excel some data which contain percentages (version 1.5). The information is displayed correctly in the crosstab and in CSV export. However, when exported to excel, the numbers appear multiplied by 100.

ie, if the value is supposed to be 25.0%,

in the graph, crosstab and csv it shows 25.0%

in the excel export it shows as 2500.0%.

I have tried changing the scale just before executing the export command and reverse it after. But it looks like the system is not changing it at all.

Any ideas are highly appreciated.

Thank you,

Alex