excel表格中的单元格格式错误怎么办
发布网友
发布时间：2024-08-20 17:13
共1个回答
热心网友
时间：2024-08-22 19:16
1，打开Excel表格程序，在Excel程序中可以看到显示###的单元格。
/iknow-pic.cdn.bcebos.com/35a85edf8db1cb130d8944a4d354564e93584ba0"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/35a85edf8db1cb130d8944a4d354564e93584ba0?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/35a85edf8db1cb130d8944a4d354564e93584ba0"/>
2，选中单元格，在右键菜单中打开“设置单元格格式”，点击打开。
/iknow-pic.cdn.bcebos.com/c2cec3fdfc039245a47799b88994a4c27c1e2542"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/c2cec3fdfc039245a47799b88994a4c27c1e2542?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/c2cec3fdfc039245a47799b88994a4c27c1e2542"/>
3，然后，在对话框中选中“文本”，点击打开。
/iknow-pic.cdn.bcebos.com/6a63f6246b600c336a44a57f144c510fd9f9a14c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/6a63f6246b600c336a44a57f144c510fd9f9a14c?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/6a63f6246b600c336a44a57f144c510fd9f9a14c"/>
4，最后，将Excel单元格中即可看到内容显示正常，问题解决。
/iknow-pic.cdn.bcebos.com/8b13632762d0f7034362ed6b06fa513d2797c5b1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8b13632762d0f7034362ed6b06fa513d2797c5b1?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/8b13632762d0f7034362ed6b06fa513d2797c5b1"/>
