csv file - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

csv file

csv file# Database - 数据库

w*j2004-06-21 07:06

1 楼

Dear all,
How to change the format of csv file.
I saved a excel file as csv file. In the cell, it can's show the first 0 of
zip code. I change the format to text, but I can't save the format. After I
closed the csv file, it changed back.
Your help is highly appreciated.

a*e2004-06-21 07:06

2 楼

If you use Excel to reopen it, you won't see the zeroes, but If you open it in
notepad or another text editor, you will see the zip codes w/ the leading
zeroes. The zeroes are there, it's just that Excel doesn't show it, and when
saving with csv format the "text" format cannot be saved.

【在 w**j 的大作中提到】

: Dear all,
: How to change the format of csv file.
: I saved a excel file as csv file. In the cell, it can's show the first 0 of
: zip code. I change the format to text, but I can't save the format. After I
: closed the csv file, it changed back.
: Your help is highly appreciated.