displaying values in excel sheet when downloaded 4404888877774143 - 4.40489E+15

[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..

[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.

[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

[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.