excel表格内数字不跟打出来的一样显示怎么处理?比如打的10000000000000显示的是1E+13

excel

1个回答

写回答

哈图

2026-02-01 22:30

+ 关注

excel
excel

这个问题可能是由于excel中的科学计数法功能导致的。科学计数法是一种表示大数的方法,其中前面的数字为整数部分,后面的数字为小数部分。解决这个问题有几种方法:1. 修改显示格式:在excel中,可以使用"格式"->"数字"->"自定义格式"来进行设置。在弹出的对话框中,在"类型"选项卡上选择"通用",然后在小数位数选项卡上选择合适的数值。保存后即可。2. 使用公式:如果只是想得到正确的显示结果,而不修改显示格式,可以使用公式来处理。假设要输入的数字为10000000000000,可以使用以下公式:=10000000000000/100000000000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000000000000000/100000

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号