I have a file with 4 columns and over 7000 rows. The columns are formatted as
But I'm using a plugging for php (
SimpleXLSX) to read the xlsx file and create queries to insert into a database.
My problem is that when I have numbers like
810001001101114 in the number column and my php file read it, the output is:
When I format the column to
Text the value becomes
8,10001E+14 (it reads
81000100110111E+14 by my php). After I edit the cell (F2), it comes back to
But I can't edit every single cell by hand. Is there a way to edit all cells by their same value or convert number cell to text cell without changing the output?