問題已解決
老師,這個(gè)表格上的銀行卡號(hào),貼到另一個(gè)表上,后幾位都變成0了,咋弄
![](https://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師
金牌答疑老師
職稱:注冊(cè)會(huì)計(jì)師,高級(jí)會(huì)計(jì)師,律師從業(yè)資格,稅務(wù)師,中級(jí)經(jīng)濟(jì)師
您好,先把表2那一列的格式設(shè)設(shè)置為文本,再粘貼為數(shù)值
2024 05/31 14:05
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 05/31 14:14
只有黏貼,沒有貼為數(shù)值的選項(xiàng)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 05/31 14:14
這個(gè)樣子的
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84785040 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2024 05/31 14:15
如圖所示
![](https://pic1.acc5.cn/016/37/51/99_avatar_middle.jpg?t=1714031960)
廖君老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2024 05/31 14:22
您好,右擊這一列,設(shè)置單元格格式,數(shù)值就可以,再復(fù)制過來,粘貼
![](/wenda/img/newWd/sysp_btn_eye.png)