在excel中怎樣張負數的數值變作0，不顯示負數只顯示0

o係你想顯示o個格打 =IF(B2 < 0," 0 ",B2) 或 按插入--> 函數, 選取函數 IF
B2係你入數值o個格

解釋
IF: 若
B2<0: B2o個格少於0
" 0 ": 顯示0
B2: 顯示返B2o個格

ctrl-1,, cell format,, custom,,
0;”0”;0

but are you sure this won't mislead the user !?