回复:excel set decimal place

来源: 2005-12-10 11:15:35 [旧帖] [给我悄悄话] 本文已被阅读:

You can highlight the whole sheet and change it to 0(from format cell). After that any number you put there will be 0 digit for decimal. But you are at the risk to lose the decimal number if your data are decimal, but you can change them back individually through format cell.