https://community.qlik.com/t5/App-Development/Format-numbers-and-money-with-leading/m-p/2125094#M91564 <P>Hello,</P> <P>after the update to August 2023 Patch 2 - 14.139.6 I have noticed following difference: With older versions I could use the number format +0,00%;-0,00%; in a straight table. After the update the format still works but the data could not be exported with keeping the format.</P> <P>Every Excel Export has the size of 9KB and could not be opened "corrupt fileformat"</P> <P>When I change the format to Auto and change the expression like below, the export works again:</P> <P>=num( ([Monatsumsatz]-[Monatsumsatz Vorjahr]), '+ #.##0,00 €; - #.##0,00 €; ')</P> <P>It seems that the problem is related to the € sign.</P> <P>1. Has anybody else noticed this behavoir?</P> <P>2. What is the best way to get a leading + for numbers, money?</P> <P>Thanks</P> <P>Niko</P> <P>&nbsp;</P> Wed, 04 Oct 2023 12:06:29 GMT nikolaus 2023-10-04T12:06:29Z https://community.qlik.com/t5/App-Development/Format-numbers-and-money-with-leading/m-p/2125094#M91564 <P>Hello,</P> <P>after the update to August 2023 Patch 2 - 14.139.6 I have noticed following difference: With older versions I could use the number format +0,00%;-0,00%; in a straight table. After the update the format still works but the data could not be exported with keeping the format.</P> <P>Every Excel Export has the size of 9KB and could not be opened "corrupt fileformat"</P> <P>When I change the format to Auto and change the expression like below, the export works again:</P> <P>=num( ([Monatsumsatz]-[Monatsumsatz Vorjahr]), '+ #.##0,00 €; - #.##0,00 €; ')</P> <P>It seems that the problem is related to the € sign.</P> <P>1. Has anybody else noticed this behavoir?</P> <P>2. What is the best way to get a leading + for numbers, money?</P> <P>Thanks</P> <P>Niko</P> <P>&nbsp;</P> Wed, 04 Oct 2023 12:06:29 GMT https://community.qlik.com/t5/App-Development/Format-numbers-and-money-with-leading/m-p/2125094#M91564 nikolaus 2023-10-04T12:06:29Z