This problem can occur when the decimal separator and the thousand separator are the same symbol, and the number of integers after the decimal separator is greater than two, as in the following example:

- In a new Excel worksheet, type 1,234.56 in cell A1.
- In cell B1, type the following equation:
=A1*3

B1 returns the value 3703.68. - On the
**Tools** menu, click **Options**.

**Note** In Microsoft Office Excel 2007, click the **Microsoft Office Button**, and then click **Excel Options**. - On the
**International** tab, change the comma to a period in the **Thousands separator** box, and then click **OK**.

**Note** In Excel 2007, click **Advanced** in the **Excel Options** dialog box. Then, change the comma to a period in the **Thousands separator** box under the **Editing options**, and then click **OK**.

You may have to click to clear the **Use System Separators** check box so that the **Decimal** and **Thousands** boxes are not dimmed.

Notice that the decimal separator and the thousands separator are now identical.
- Select cell A1, and then add a 7 to the string so that the value reads 1234.567. Then, press ENTER.
Notice that the formula in cell B1 returns 3703701. The value has increased by a factor of 1000.