Export to MS Excell, last digit turn into zero |
Hello
Right now i already success in exporting my data from my CI website ( mine use mysql) into MS excell . But if the data digit if bigger than 16, it digit turn into zero. For example,,in mysql my data is 12345678912345678, but after i export it into MS EXcel it change to 12345678912345670. I google and it says that ms excell change last digit into zero it if number if greater than 16 digit. I already try to change datatype in mysql from varchar to tinytext, but the problem still happen. How to solve it? Thanks. |
Messages In This Thread |
Export to MS Excell, last digit turn into zero - by kelapamuda - 03-13-2020, 02:12 AM
RE: Export to MS Excell, last digit turn into zero - by zahhar - 03-13-2020, 01:55 PM
RE: Export to MS Excell, last digit turn into zero - by kelapamuda - 03-22-2020, 09:42 PM
|