Export to excel Decimal point issue

[Mahamed_Qlik]

Hi All,

Issue -

Export to excel from straight table, the values are showing one decimal in excel is correct, but if I select the value in excel it is showing in 4 decimal.

Qlikview straight table  :

Now after exporting to excel using upper right corner, I am getting the same result but if you can see, when I select 1.1 valuse in excel then it is shwoing as 1.13984, so it should be 1.1, this is what I am execting

Note-

- Dont suggest to create export button and to write macro, it is not required.

- I have tried to change the number format in Number tab #,##0.0

- I have use NUm fucntion with expression to show as result in #,##0.0

Kindly provide the solution.

Best Regards,

Mahamed

[antoniotiman]

HiMahamed,

use Round(YourExpression,0.1)

Regards,

Antonio