如何在excel上把数值转换文本格式在小数点后保留两位?

如题所述

利用单元格格式设置。

    在原来的数值上右击跳出单元格格式设置框

    /iknow-pic.cdn.bcebos.com/f9dcd100baa1cd11cb7347dcb512c8fcc2ce2d00"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f9dcd100baa1cd11cb7347dcb512c8fcc2ce2d00?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f9dcd100baa1cd11cb7347dcb512c8fcc2ce2d00"/>

    然后点击“设置单元格格式”,选择“数值”,然后在右边选择“小数位数”,选择2,再按确定就可以了

    /iknow-pic.cdn.bcebos.com/e850352ac65c10380789fa3ebe119313b17e8952"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/e850352ac65c10380789fa3ebe119313b17e8952?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/e850352ac65c10380789fa3ebe119313b17e8952"/>

    选择小数位数为两位数之后,点击确定,那么你原来的数值就会自定四舍五入转换成两位小数点的数值了

    /iknow-pic.cdn.bcebos.com/50da81cb39dbb6fd9ff4d2da0524ab18962b379a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/50da81cb39dbb6fd9ff4d2da0524ab18962b379a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/50da81cb39dbb6fd9ff4d2da0524ab18962b379a"/>

温馨提示:答案为网友推荐,仅供参考
相似回答
大家正在搜