Excel表格数值去除小数点,然后求和,不需要四舍五入且求和不要把小数点也求和。可通过分列功能直接将小数点后面的内容删除,再进行整数部分求和。
方法步骤如下:
1、打开需要操作的EXCEL表格,在数据选项卡中点击“分列”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42166d224f4a20a4d1759c219e529822730ed0e9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、使用分隔符,点击下一步。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b64543a98226cffc435f1f54b7014a90f703eadb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、勾选“其他”并输入小数点“.”,然后点击完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a08b87d6277f9e2f7341bdee1130e924b999f3e4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、发现成功将整数部分分离出来,选中整数部分下方单元格,点击开始选项卡中的“自动求和”即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fbd05df8f4414a20a44723dce6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、返回EXCEL表格,发现在Excel表格中数值去除小数点,然后求和,不需要四舍五入且求和不要把小数点也求和操作完成。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/730e0cf3d7ca7bcb95df67c9b0096b63f724a8b4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)