The value "1000.00" is displayed as "1000.00.00" in Excel when opening a HTML page

Question

The following fake excel file:

<style> .text { mso-number-format:\@; }</style>
<div>
    <table class="results" cellspacing="0" rules="all" border="1" id="ctl00_content_grdData" style="border-collapse:collapse;">
        <thead>
            <tr>
                <th scope="col">A</th><th scope="col">B</th><th scope="col">C</th><th scope="col">D</th>
            </tr>
        </thead><tbody>
            <tr>
                <td class="text">1000</td><td>1000.00</td><td>1000,00</td><td>1.000,00</td>
            </tr>
        </tbody>
    </table>
</div>

Is displayed in Excel 2007 as

Notice that column B is displayed like "1000.00.00".

Additional information: The regional / language settings from Windows are set to 'Italy'.

How is this possible, and how to solve this ?

Note : I used different values, just to show the different behaviour from Excel.

Edit 2
When I put the value '1000.00' in column A (the column which has the class 'text' on the td-element, the value is displayed exactly as it should in Excel:

Answer 1

According to the Italian locale, 1000.00 is displayed as 1000.00.00 because is recognized as time (like a period of time). So the first number is the hours, then the minutes, then the seconds.

In OpenOffice, but should be the same in Excel, I checked the time format with Italian locale is: "HH.MM.SS".

Answer 2

You are mixing the display types of numbers in your spreadsheet.

<td class="text">1000</td><td>1000.00</td><td>1000,00</td><td>1.000,00</td>

Note that the first number is 1000, the second has a period to separate the decimal, the third has a comma to separate the decimal (as does the last).

If you make them all consistent - period for decimals, comma for thousands separator, everything should work.

The period thousands separator and comma decimal separator is a European style which Excel defaults to Italian for. It then gets confused by the one number that doesn't fit the pattern.