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.