https://community.qlik.com/t5/QlikView/Number-Format-for-a-calculated-field-in-script/m-p/1566589#M743388 try Num(round(MonthsEnd(1,Today(),-1)-OrderDate),'#,##0') Mon, 08 Apr 2019 18:42:34 GMT dplr-rn 2019-04-08T18:42:34Z https://community.qlik.com/t5/QlikView/Number-Format-for-a-calculated-field-in-script/m-p/1566578#M743387 <P>I have a field that I am calculating in my script and I can't seem to get the format correct.&nbsp; Here is the code in my script to create the field:</P><P>&nbsp;</P><P>Num(MonthsEnd(1,Today(),-1)-[Posting Date],'#,##0') as DaysAged</P><P>&nbsp;</P><P>I want this to be a number without decimals.&nbsp; When I look at the values in a list box, it looks fine, but when I export the data to Excel, I still see the decimals.&nbsp; How can I make it a whole number when exporting to Excel?</P> Sat, 16 Nov 2024 03:55:06 GMT https://community.qlik.com/t5/QlikView/Number-Format-for-a-calculated-field-in-script/m-p/1566578#M743387 cliff_clayman 2024-11-16T03:55:06Z https://community.qlik.com/t5/QlikView/Number-Format-for-a-calculated-field-in-script/m-p/1566589#M743388 try Num(round(MonthsEnd(1,Today(),-1)-OrderDate),'#,##0') Mon, 08 Apr 2019 18:42:34 GMT https://community.qlik.com/t5/QlikView/Number-Format-for-a-calculated-field-in-script/m-p/1566589#M743388 dplr-rn 2019-04-08T18:42:34Z