Value when exported to excel is different from shown in app

[#1]

Hi,

In a chart, I have some values displayed say suppose 314.82   but when I export the chart to excel; 314.826345 is being displayed in number formatting of qlikview app I restricted the values to two decimal places but still it is showing up to 2 decimal places in app but displaying values more than 2 decimal places when I export to excel.

Any reason and solution pls...

[Anonymous]

Hi

Have a look:

Re: Number Format Issue

HTH

[bindu_apte]

Hi,

Have you did like this which is in attachment? If yes then let me know whether you are using browser as ajax or IE

[trdandamudi]

See if the attached is helpful...

[Anil_Babu_Samineni]

Because, You restricted in Qlikview. So if you want to same format in Excel. Might be you need to change Custom format.