Forum Discussion
Excel Exponential format problem
Hi Anonymous ,
That is a limitation of excel itself as you can see in the link below excel only saves the first 15 numbers, so even if you add a xlsx you would get zeros and not the values.
On the first post you add the exponential was of 14 so everything worked properly, if you are abble to extract in text, csv or similar maybe the issue can be solved.
Microsoft EmployeeDo you plan to keep the text and numbers in the same column ultimately? One thing you could do is duplicate the column, convert one to # and the other to text, replace the errors with null. That way you will have a column with #s for calculations and another column with your text values.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat Thanks very much for your reply. Unfortunately I still lose my last digits, they just turn to zeros. Ie 8,69113E+24 becomes 8691130400900000000000000.
I've noticed the problem goes away when open the doc and save as .xlsx. The original is a .xls. The data source is an export from an old software program and exporting as .xlsx is not an option 😞