+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: displaying values in excel sheet when downloaded 4404888877774143 - 4.40489E+15 (/showthread.php?tid=49725)
displaying values in excel sheet when downloaded 4404888877774143 - 4.40489E+15 - El Forum - 03-01-2012
[eluser]Ram_Kalva[/eluser]
big numeric values like 4404888877774143 or 123456789 are displayed in scientific notation in excel sheet when downloaded …
====================================================
number - value displayed in excel
====================================================
4404888877774143 - 4.40489E+15
123456789 - 1.23E+08
how do i display the values to normal full values format in excel sheet?
please help..
displaying values in excel sheet when downloaded 4404888877774143 - 4.40489E+15 - El Forum - 03-01-2012
[eluser]xeroblast[/eluser]
sorry dude but wrong forum. you should ask the MS excel forum.
i already forgot how to do this in MS excel but in openoffice/libreoffice calc, you could just extend the width of the column to view the proper values.
displaying values in excel sheet when downloaded 4404888877774143 - 4.40489E+15 - El Forum - 03-01-2012
[eluser]Ram_Kalva[/eluser]
Hi there this is coming when i am trying to downloading the sheet from code igniter framwork the excel sheet but i am not able to do that so can u please tell me if any code or function need to keep their
displaying values in excel sheet when downloaded 4404888877774143 - 4.40489E+15 - El Forum - 03-01-2012
[eluser]xeroblast[/eluser]
there is nothing wrong with the code. the problem lies in the ms excel, there is a setting not to view the scientific notation in ms excel.