原文地址:http://support.pitneybowes.com/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA280000000TTCfCAO&popup=false&lang=en_US
To convert the tracking number from scientific notation to text:
- Close the CSV file in Excel.
- Open a new blank Excel file.
- Select the Data tab.
- Select From Text.
- Select the transactions.csv file and select Import.
- In the Text Import Wizard, select Delimited and My data has headers. Select Next.
- Uncheck Tab, select Comma, and select Next.
- Select Package Tracking Number column.
- Select Text and select Finish.
- In the Import Data window, select OK.
1、关闭csv文件
2、打开excel,新建空白页
3、选择 “数据”
4、选择“自文件”
5、选择“你的.csv”文件,选择导入
6、在弹窗的窗口,选择“分隔符号”,勾选“数据包含标题”,下一步
7、选择分隔符号(跟进自己情况,同时为逗号,笔者为分号),下一步
8、选择要转换成问题的数列
9、列数据格式选择“文本”,点击“完成”
10、选择“确定”。数据即导入成功