问题已解决
请问这种怎么改成数字
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/18/11/88_avatar_middle.jpg?t=1739494013)
你好,在数字前面加一个引号就可以
2022 09/21 20:46
![](https://pic1.acc5.cn/009/18/11/88_avatar_middle.jpg?t=1739494013)
QQ老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/21 20:47
或者是在单元格属性里把他改成文本格式试试
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/21 20:48
是从系统里面导出的快递单号,要怎么才能变成单号
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/21 20:48
是设置单元格吗
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/21 20:54
还是不行呢
![](https://pic1.acc5.cn/009/18/11/88_avatar_middle.jpg?t=1739494013)
QQ老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/21 20:54
选择这一列,然后右击设置单元格里面把他改成文本格式试一下
![](https://pic1.acc5.cn/009/18/11/88_avatar_middle.jpg?t=1739494013)
QQ老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/21 20:55
不可以吗?那你们的单据号首位不是零吧?如果不是零的话改成数字模式试一下
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84785044 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 09/21 21:02
我们的单号首位是6
![](https://pic1.acc5.cn/009/18/11/88_avatar_middle.jpg?t=1739494013)
QQ老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 09/21 21:26
你好!那就改成数字格式