search

codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

Reading large numbers from excel returns exponential numbers #33

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. insert a number like "3421523452345645365345" in the excel file and do not 
format it as text or number
2. use linqtoexcel
3.it returns a number like 6546e+009

Original issue reported on code.google.com by sky.prog...@gmail.com on 11 Feb 2011 at 10:56

GoogleCodeExporter commented 8 years ago 
You will need to edit the cell format in Excel and format it as a text value, 
then the full number will show up.

Original comment by paulyo...@gmail.com on 23 May 2011 at 3:57