打开CSV时保留小数位 [英] Keep decimal places when open CSV

问题描述

 13,423.354679，
  

当我在Excel中打开它时，看起来像这样：

 code> 13,423.35 
  

我可以通过手动更改格式让它正确显示。 >

有没有办法在Excel中保持正确显示格式？

解决方案

p>你可以显示尽可能多的，包括没有。

并使用1000分隔符选项拆分你想要的数字= 13,423.35。

是的，你不能通常有实际的逗号，形成选项只是把它们放在视觉外观上 - 但是如果你真的想要他们有人可以在1分钟内写一个vba。请记住，如果excel中有实际的逗号，则通常不能正常使用数字。您必须复制数据，以防您想要使用数字并具有它们的输出。如果您可以使用= SUBSTITUTE（）删除它们，并且具有VBA或一个聪明的公式，则将它们重新放入以最终使用数据。

如果是图像损失：
主页>数字格式（通常在哪里）>更多数字格式>类别编号>小数位置控制器。

如果由于某些原因，它们会丢失在导入 - 只是打开csv与其他东西，并将数字复制粘贴到excel。

I have a .csv file looks like this:

"13,423.354679",

When I open it in Excel it looks like this:

13,423.35

I can let it show correctly by changing the format manually.

Is there a way I can keep it shown correctly without formatting in Excel?

解决方案

You can show as many as you want, including none.

AND use the 1000 separator option to split the numbers like you want = 13,423.35.

And yes you can't normally have the actual commas, the formating option just puts them there for visual appearance - but if you really want them someone can write you a vba in 1 minute. Keep in mind excel can't work with the numbers normally if they have actual commas in them. You have to duplicate the data in case you want to both work with the numbers and have an output that has them. In case one you can remove them with =SUBSTITUTE() and have VBA or a clever formula put them back in for your final use of the data.

In case of image loss: Home > Number Format (where it says General) > More Number Formats > Category Number > Decimal Places controller.

If for some reason they get lost on import - just open the csv with something else and copy-paste the numbers into excel.

这篇关于打开CSV时保留小数位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！