topic How to save Exponential number in QlikView https://community.qlik.com/t5/QlikView/How-to-save-Exponential-number/m-p/64330#M10706 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am facing one problem while saving data where between numbers E appears. It automatically converts values in Exponential so while saving data it converts into 0.</P><P></P><P>Actual member number in front of 123567 is 00E24 and where as in front of 45678 value is 00E23.</P><P>In excel also value getting converted into exponential.</P><P></P><P>Can you pl help to resolve the issue.</P><P></P><P>Thanks in Advance. </P><P></P><P><A href="https://community.qlik.com/qlik-users/2454">sunny</A>‌</P><P><A href="https://community.qlik.com/qlik-users/27943">marcus_sommer</A>‌</P></BODY></HTML> Thu, 05 Apr 2018 16:23:22 GMT pra_kale 2018-04-05T16:23:22Z How to save Exponential number https://community.qlik.com/t5/QlikView/How-to-save-Exponential-number/m-p/64330#M10706 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am facing one problem while saving data where between numbers E appears. It automatically converts values in Exponential so while saving data it converts into 0.</P><P></P><P>Actual member number in front of 123567 is 00E24 and where as in front of 45678 value is 00E23.</P><P>In excel also value getting converted into exponential.</P><P></P><P>Can you pl help to resolve the issue.</P><P></P><P>Thanks in Advance. </P><P></P><P><A href="https://community.qlik.com/qlik-users/2454">sunny</A>‌</P><P><A href="https://community.qlik.com/qlik-users/27943">marcus_sommer</A>‌</P></BODY></HTML> Thu, 05 Apr 2018 16:23:22 GMT https://community.qlik.com/t5/QlikView/How-to-save-Exponential-number/m-p/64330#M10706 pra_kale 2018-04-05T16:23:22Z Re: How to save Exponential number https://community.qlik.com/t5/QlikView/How-to-save-Exponential-number/m-p/64331#M10707 <HTML><HEAD></HEAD><BODY><P>It appears that Excel is not even holding the value 00E24. The value itself is being saved as "0".</P><P>Is it an option to update the source? say - format of the cell as text?</P></BODY></HTML> Thu, 05 Apr 2018 16:48:55 GMT https://community.qlik.com/t5/QlikView/How-to-save-Exponential-number/m-p/64331#M10707 boorgura 2018-04-05T16:48:55Z Re: How to save Exponential number https://community.qlik.com/t5/QlikView/How-to-save-Exponential-number/m-p/64332#M10708 <HTML><HEAD></HEAD><BODY><P>Hi, try use Round(YourData)</P></BODY></HTML> Thu, 05 Apr 2018 17:07:11 GMT https://community.qlik.com/t5/QlikView/How-to-save-Exponential-number/m-p/64332#M10708 eduardo_dimperio 2018-04-05T17:07:11Z