topic Convert Scientific notation to Number format using Macro to export to excel in QlikView https://community.qlik.com/t5/QlikView/Convert-Scientific-notation-to-Number-format-using-Macro-to/m-p/953092#M327679 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>In Qlikview , I have converted all values into number. But When am exporting same to excel using macro still its showing in Scientific notation.</P><P></P><P>In chart, I have used function to convert exponential notation to number</P><P>=if(isnum(ReqNumber)=-1, num(ReqNumber,'#############0'), ReqNumber). Now in Qlikview its changed i.e all it is showing in number format.</P><P></P><P>But in Excel while exporting using macro,it is showing 1.5E + 12. </P><P></P><P>Can anyone please help me how to implement using macros?</P><P></P><P></P><P></P><P>Regards,</P><P>Nisha.</P></BODY></HTML> Wed, 19 Aug 2015 11:03:51 GMT Anonymous 2015-08-19T11:03:51Z Convert Scientific notation to Number format using Macro to export to excel https://community.qlik.com/t5/QlikView/Convert-Scientific-notation-to-Number-format-using-Macro-to/m-p/953092#M327679 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>In Qlikview , I have converted all values into number. But When am exporting same to excel using macro still its showing in Scientific notation.</P><P></P><P>In chart, I have used function to convert exponential notation to number</P><P>=if(isnum(ReqNumber)=-1, num(ReqNumber,'#############0'), ReqNumber). Now in Qlikview its changed i.e all it is showing in number format.</P><P></P><P>But in Excel while exporting using macro,it is showing 1.5E + 12. </P><P></P><P>Can anyone please help me how to implement using macros?</P><P></P><P></P><P></P><P>Regards,</P><P>Nisha.</P></BODY></HTML> Wed, 19 Aug 2015 11:03:51 GMT https://community.qlik.com/t5/QlikView/Convert-Scientific-notation-to-Number-format-using-Macro-to/m-p/953092#M327679 Anonymous 2015-08-19T11:03:51Z