excel保留2位小数
时间: 2023-09-22 08:11:22 浏览: 103
保留2位小数
在Excel中保留两位小数的方法是,选择你想要设置的单元格或单元格区域,然后右键点击,选择"单元格格式"。在弹出的对话框中,选择你想要的格式(如常规、货币、会计专用等),然后在小数位数中输入"2",表示保留两位小数。这样,该单元格中的数据就会自动四舍五入保留两位小数了。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [excel怎么设置保留两位小数?](https://blog.csdn.net/weixin_45707610/article/details/125457847)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [经纬度的秒保留2位小数模板.xlsx](https://download.csdn.net/download/qq_28011227/12188118)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [excel表格数据取一位小数-excel保留一位小数](https://blog.csdn.net/weixin_39959794/article/details/119127147)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]
阅读全文