• 1097閱讀
  • 17回復

Excel 加數問題 [復制鏈接]

上一主題 下一主題
離線迪神
發帖
42336
好友元
47777
閱讀權限
120877
貢獻值
5
只看該作者 15  發表于: 2014-05-12


係咪你呢度SETTING有野咋,冇咩理由開新EXCEL都係咁
離線鮮吊甬仔
發帖
6690
好友元
198291
閱讀權限
22355
貢獻值
1
只看該作者 16  發表于: 2014-05-12
回 迪神 的帖子
迪神:[圖片]
係咪你呢度SETTING有野咋,冇咩理由開新EXCEL都係咁[表情] (2014-05-12 19:48) 

同你果個exactly the same
離線MatthewB
發帖
18716
好友元
2168
閱讀權限
18916
貢獻值
3
只看該作者 17  發表于: 2014-05-12
Precision as Displayed

In some cases, you may be able to prevent rounding errors from affecting your work by using the Precision as displayed option. This option forces the value of each number in the worksheet to be the displayed value. To turn on this option, follow these steps:
In Excel 2003 and in earlier versions, click Options on the Tools menu.
On the Calculation tab, click to select the Precision as displayed check box.
In Excel 2007, click the Microsoft Office Button, click Excel Options, and then click the Advancedcategory.
In the When calculating this workbook section, select the workbook you want, and then select the Set precision as displayed check box.
In Excel 2013 and 2010, click File, and then Options, and then click the Advanced category.
In the When calculating this workbook section, select the workbook you want, and then select the Set precision as displayed check box.

For example, if you choose a number format showing two decimal places and then turn on the Precision as displayed option, all accuracy beyond two decimals will be lost when you save your workbook. This option affects the active workbook including all worksheets. You cannot undo this option and recover the lost data. It is recommended that you save your workbook prior to enabling this option.