Data format changed after downing data from visualization to excel file

[vincentma]

We have a AGE column in a table, but after download the data from the table to excel file, the format of the data was changed to Currency, which looks very strange.  Is there any setting for download data format?  Thanks!

[Ksrinivasan]

hi,

use this syntax

Num(round(Field1,0.01), '# ##0,00 '

ksrinivasan

[vincentma]

This need to add by field level in every APP, we have many APPs, is there a site level setting?  Or is it a bug of Nov 2020 version?  It happened after I upgrade Qlik Sense from Nov 2019 to Nov 2020.