11

excel 打开 csv 文件 日期格式不一致

 2 years ago
source link: https://www.oschina.net/question/1175066_2324707
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

excel 打开 csv 文件 日期格式不一致

zgw06629 发布于 今天 15:33

导出csv 日期格式如下 

时间
2021-10
2021-09
2021-08
2021-07
2021-06
2021-05
2021-04
2021-03
2021-02
2021-01
2020-12
2020-11
2020-10

但是excel打开 日期变成了

Qct-21

Sep-21

Aug-21

请问 有没什么方法 解决这一问题呢?即excel打开后 原样展示 如 2021-10


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK