第二個位係0果陣,好似9.10 , 205.00 , 107.50依幾個數
佢同我自動食晒後面d零,好嬲
交功課講明要顯示小數點後2位...
我點set死佢一定要顯示?
點樣規定excel要顯示小數點後2個位
2007-12-07 11:36 am
回答 (2)
2007-12-07 5:08 pm
✔ 最佳答案
儲存格上右Click, 儲存格格式, 在"數值"-> 類別 -> 選"數值" -> 小數位數 Set做2 就可以.
2007-12-07 5:40 pm
"功課講明要顯示小數點後2位" does not mean numbers must be padded with zero at the second decimal place.
excel will show numbers with non-zero second decimal 1.23
anyway, right click the cell, choose format, custom format, you can have any number of leading/trailing zero and other format mask you like.
excel will show numbers with non-zero second decimal 1.23
anyway, right click the cell, choose format, custom format, you can have any number of leading/trailing zero and other format mask you like.
收錄日期: 2021-04-11 19:31:23
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071207000051KK00377