如何将excel列保存到csv中? [英] how to save excel columns with long numbers into csv?

查看:185
本文介绍了如何将excel列保存到csv中?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

有趣的事情,当我想保存excel列长数字如下,导致csv包含转换的数字科学符号是不可用的。我希望他们保存为文本。任何诀窍?

funny thing when I want to save excel columns with long numbers like below, resulting csv contains converted numbers to scientific notation which is unusable. I want them to be save as text. Any trick to do that?

28160010390002003505456159

12160010390002003505456156

39160010390002003505456155

39160010390002003505456155

28160010390002003505456159
12160010390002003505456156
39160010390002003505456155
39160010390002003505456155

谢谢

推荐答案

为了让这些长(> 15位数)的数字Excel,它们已经被格式化为文本。我怀疑.csv文件也显示为长数字(如果使用记事本打开csv文件),但是当您在Excel中打开csv文件时,会将其视为截断并转换为科学记数法。

In order to have those long (>15 digit) numbers in Excel, they are already formatted as text. I suspect that the .csv file also shows them as long numbers (if you open the csv file with Notepad), but that when you open the csv file in Excel, you see them as truncated and converted to scientific notation.

如果是这种情况,您需要做的是导入csv文件。当您这样做时,文本到列向导将打开,并允许您将该列格式化为文本。导入的位置在不同的版本是不同的。在Excel 2007中,它位于数据功能区,获取外部数据/文本。

If that is the case, what you need to do is IMPORT the csv file. When you do that, the text-to-columns wizard will open, and allow you to format that column as text. The location of the Import is different in different versions. In Excel 2007, it is on the Data ribbon, Get External Data / From Text.

这篇关于如何将excel列保存到csv中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆