如何将长数字的excel列保存到csv中? [英] How to save excel columns with long numbers into 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  

推荐答案

为了在 Excel 中拥有那些长(> 15 位)数字，它们已经被格式化为文本.我怀疑 .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 文件.当您这样做时，文本到列向导将打开，并允许您将该列格式化为文本.不同版本的Import位置不同.在 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屋！