点分十进制转化为十进制_如何将Excel的十进制分隔符从句点更改为逗号

最新推荐文章于 2023-09-05 19:59:28 发布

culun797375

最新推荐文章于 2023-09-05 19:59:28 发布

阅读量710

点赞数

文章标签： java linux excel shell git

原文链接：https://www.howtogeek.com/245510/how-to-change-excels-decimal-separators-from-periods-to-commas/

版权

点分十进制转化为十进制

In the US, we use a period, or point, as a decimal separator (1.23). The same is true in the UK and Australia. However, other European countries use the comma as a decimal separator instead. Different delimiters are also used for separating thousands groups (1,000).

在美国，我们使用点或点作为小数点分隔符(1.23)。英国和澳大利亚也是如此。但是，其他欧洲国家/地区则使用逗号作为小数点分隔符。不同的定界符也用于分隔数千个组(1,000)。

Say you’re creating different price lists for different countries. To display the prices correctly for each country, it would be helpful to be able to specify the characters used for decimals in prices and for separating thousands groups so you can keep each number formatted as a currency number for use in formulas if needed. We’ll show you how you can change the decimal and thousands separators in Excel.

假设您要为不同的国家/地区创建不同的价格表。为了正确显示每个国家/地区的价格，能够指定价格中用于小数的字符以及分隔成千上万个组将很有帮助，因此您可以根据需要将每个数字保留为货币数字格式，以便在公式中使用。我们将向您展示如何在Excel中更改小数和千位分隔符。

NOTE: When you change this setting, it affects all the numbers in all workbooks you open from then on, until you change it again. You cannot change this setting only for certain cells. However, when working with different currencies, you can change the currency symbol for certain cells.

注意：更改此设置后，此设置将影响此后打开的所有工作簿中的所有数字，直到您再次对其进行更改。您不能仅对某些单元格更改此设置。但是，当使用不同的货币时，可以更改某些单元格的货币符号。

To change the types of decimal and thousands separators used in Excel, click the “File” tab.

要更改Excel中使用的小数和千位分隔符的类型，请单击“文件”选项卡。

On the backstage screen, click “Options” in the list of items on the left.

在后台屏幕上，单击左侧项目列表中的“选项”。

The Excel Options dialog box displays. Click “Advanced” in the list of items on the left.

将显示“ Excel选项”对话框。在左侧的项目列表中单击“高级”。

In the Editing options section, click on the “Use system separators” check box so there is NO check mark in the box.

在“编辑选项”部分中，单击“使用系统分隔符”复选框，以使该框中没有复选标记。

The “Decimal separator” and “Thousands separator” edit boxes become available. Enter the character you want to use for each in the edit boxes and click “OK”. For our example, we are using a comma as the Decimal separator and a period as the Thousands separator.

“小数点分隔符”和“千位分隔符”编辑框变为可用。在编辑框中输入要用于每个字符的字符，然后单击“确定”。对于我们的示例，我们使用逗号作为小数分隔符，使用句点作为千位分隔符。

The new separators are automatically inserted into all the numbers in your workbook that use them.

新的分隔符会自动插入到您使用它们的工作簿中的所有数字中。

If you want to change the decimal and thousands separators in Windows for any program (not just Excel) that displays decimal numbers and large numbers, you can change the “Decimal symbol” and “Digital grouping symbol” on the same dialog box (Customize Format) where you can change the currency symbol for Windows. You can also change the number of digits after the decimal point and even how thousands are grouped. In addition to using different thousands separator symbols, some countries group the thousands in number differently.

如果要在Windows中更改任何显示十进制数字和大数字的程序(不仅是Excel)的十进制和千位分隔符，可以在同一对话框中更改“十进制符号”和“数字分组符号”(自定义格式) )，您可以在其中更改Windows的货币符号。您还可以更改小数点后的位数，甚至分组的位数。除了使用不同的千位分隔符符号外，某些国家/地区还以不同的方式对千位进行分组。