https://community.qlik.com/t5/Suggest-an-Idea/Measure-expression-doesn-t-correspond-to-Excel-Formating/idi-p/1879871 <P>When I use this measure and download as Data, Format is different to Qlik in Excel.</P> <P>measure：If(Sum(column)&lt;=1,num(sum(column),'#.##'),num(sum(column),'#.###'))</P> <P>In Excel, this data will be "standard format".<BR />I want these data will be formated as with Qlik Sense.</P> Wed, 12 Jan 2022 05:24:50 GMT kka_rnishida 2022-01-12T05:24:50Z https://community.qlik.com/t5/Suggest-an-Idea/Measure-expression-doesn-t-correspond-to-Excel-Formating/idc-p/2015107#M11255 <P>I ran into this situation recently, my measure in Qlik Sense was set to auto.&nbsp; When I changed it to the measure format to <EM>Number</EM>&nbsp; and set the cutom format it the xls number formatting I was looking for appeared.&nbsp;&nbsp;</P> Sat, 10 Dec 2022 17:50:15 GMT https://community.qlik.com/t5/Suggest-an-Idea/Measure-expression-doesn-t-correspond-to-Excel-Formating/idc-p/2015107#M11255 Andrew_Kruger 2022-12-10T17:50:15Z