EXCEL中数字默认显示11位,如果超过11位,将以科学记数法显示,如果位数较多,又要完整显示,方法如下:
右击单元格--设置单元格格式--数字--文本,设置为文本格式,再输入数字,此时会在左上角看到一个绿色小三角,提醒这是文本格式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d6e5b2d355010828381e30fd8c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
先输入英文单引号,再输入数字,同样也是文本格式;
如果已经输入了数值型数字,且显示为科学记数法,右击单元格--设置单元格格式--数字--文本,设置为文本格式;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/38dbb6fd5266d01683c8e662912bd40734fa35a2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
但此时并没有改变,仍是科学记数法,双击单元格,即按文本格式显示;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8014c086e061d95c6304c727df40ad162d9ca02?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
但如果超过15位,后面的将显示为0,只能修改或重新输入。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b03533fa828ba61ef52cb3654734970a314e59bd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)