Opening HTML Table in Excel - numbers are getting changed

Posted by nickfranceschina on Stack Overflow See other posts from Stack Overflow or by nickfranceschina
Published on 2010-04-09T20:36:55Z Indexed on 2010/04/09 20:43 UTC
Read the original article Hit count: 411

Filed under:
|

so I have this HTML table with a bunch of big numbers in it that I want to open in Excel 2007... you can follow along at home:

<table>
<tr>
    <td>this is a big number</td>
</tr><tr>
    <td>1111111</td>
</tr><tr>
    <td>2335322864</td>
</tr><tr>
    <td>23353228641</td>
</tr><tr>
    <td>233532286418</td>
</tr><tr>
    <td>2335322864187</td>
</tr><tr>
    <td>23353228641877</td>
</tr><tr>
    <td>233532286418777</td>
</tr><tr>
    <td>2335322864187774</td>
</tr><tr>
    <td>23353228641877745</td>
</tr><tr>
    <td>233532286418777456</td>
</tr><tr>
    <td>2335322864187774562</td>
</tr><tr>
    <td>23353228641877745623</td>
</tr><tr>
    <td>233532286418777456238</td>
</tr>

when I open this file in Excel it starts converting those numbers to scientific notation when they get over 10 digits in length... and in doing so, it starts changing the actual number and replaces least significant digits to zeros

how can I tell Excel not to do this?

© Stack Overflow or respective owner

Related posts about excel-2007

Related posts about html