標題: excel有冇辦法可以cut左d小數點 [打印本頁]

---

作者: Oatrina    時間: 2007-7-12 09:04     標題: excel有冇辦法可以cut左d小數點

而又唔係四寫五入, 即係cut off, 唔係round off.

p.s.唔可用TRUNC() function, 要晌儲存格格式到整


Thanks

---

作者: herman    時間: 2007-7-12 14:36

in cell A1
=ROUNDDOWN(B1,0)

in cell B1
enter 小數點數據

---

歡迎光臨 PC Infinity (http://pcinhk.com/discuz/)

Powered by Discuz! 7.0.0