EXCEL表格中把淘宝长串的订单号设置为正常的数字显示,通过选择项粘贴将订单号粘贴为文本格式即可。方法步骤如下:
1、打开需要操作的EXCEL表格,通过淘宝复制的订单号,在EXCEL表格中点击鼠标右键,选择“选择性粘贴”。
2、在弹出的窗口中点击选择“文本”,然后点击确定即可。
3、返回EXCEL表格,发现成功将长串订单号在EXCEL中正常显示出来了。
Set the long string of Taobao order numbers to normal digital display in EXCEL, and paste the order number as text format by selecting Paste. The steps are as follows:
1. Open the EXCEL table that needs to be operated, click the right button of the mouse in the EXCEL table to select the order number copied from Taobao, and select "Paste Special".
2. Click "Text" in the pop-up window, and then click OK.
3. Return to the EXCEL table and find that the long string of order numbers has been successfully displayed normally in EXCEL.