Excel：更改“，” “”。 [英] Excel: Change "," to "."

问题描述

自从我为我的电脑添加了多种语言选项以来，Excel决定将所有的小数位都转成逗号。我需要再次将它们转成小数。我如何做最少的工作这样做？如果你知道一个简单的方式来做，请强调容易，请告诉。当它被转换时，我需要一个数字，而不是文本或其他任何东西。我正在使用Microsoft Office Professional Plus 2010。

我尝试了在Excel中创建此公式的方法

  = SUBSTITUTE（A4;，;。）+ 0 
  

$ b $我应该假设，要获取单元格A4，将逗号更改为句点，然后将0转换为数字。我的原始数字是17.6，现在我得到41807。

解决方案

有两个选项。

1）更改在VBA代码（例如在 Workbook_Open 事件）：

  Private Sub Workbook_Open（）
 Application.DecimalSeparator =。 
 End Sub 
  

Ever since i added a multiple language option for my computer, Excel decided to turn all my decimals into commas. I need to turn them back into decimals again. How do i do this with least amount of work? If you know an EASY way to do this, emphasis on easy, please tell. When it is converted, i need a number, not text or anything else. I'm using Microsoft Office Professional Plus 2010.

I tried the approach where you make this formula in Excel

=SUBSTITUTE(A4;",";".")+0

Which should, i'm assuming, get cell A4, change comma into period and then by adding 0 convert to number. My original number is 17.6, now i'm getting 41807.

解决方案

There're two options for you.

1) change regional settings on your PC:

2) use Application.DecimalSeparator in VBA code (e.g. in Workbook_Open event):

Private Sub Workbook_Open()
    Application.DecimalSeparator = "."
End Sub

这篇关于Excel：更改“，” “”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！