如何更改Excel中某些单元格的货币符号

If you’re working with different currencies in one Excel spreadsheet, you’ll need to change the currency symbol on certain cells, without affecting other cells. When you format your numbers as “Currency”, you can easily use multiple currency symbols in the same Excel spreadsheet.

如果您在一个Excel电子表格中使用不同的货币，则需要在某些单元格上更改货币符号，而又不影响其他单元格。 将数字格式设置为“货币”时，可以在同一Excel电子表格中轻松使用多个货币符号。

NOTE: If you’re going to use the same currency symbol throughout your Excel spreadsheets, you can change the default currency symbol throughout Windows instead. This is for situations when you want two different currency symbols in the same document.

注意：如果要在整个Excel电子表格中使用相同的货币符号，则可以改为在Windows中更改默认货币符号 。 这是在同一文档中需要两个不同货币符号的情况。

Before you do anything else, make sure the numbers in question are formatted as currency. To do this, select the cells you want to format.

在执行其他任何操作之前，请确保所讨论的数字的格式设置为货币。 为此，选择要格式化的单元格。

Then, select “Currency” from the “Number Format” drop-down list in the “Number” section of the “Home” tab.

然后，从“主页”选项卡的“数字”部分的“数字格式”下拉列表中选择“货币”。

The numbers in the selected cells are all formatted as currency with Windows’ default currency symbol applied.

所选单元格中的数字均已格式化为货币，并应用了Windows的默认货币符号 。

To change some of the currency numbers to another type of currency, such as Euros, select the cells you want to change.

要将某些货币编号更改为另一种类型的货币，例如欧元，请选择要更改的单元格。

In the “Number” section of the “Home” tab, click he “Number Format” button in the lower-right corner of the section.

在“主页”选项卡的“数字”部分中，单击该部分右下角的“数字格式”按钮。

On the “Number” tab, “Currency” should be selected in the “Category” list. Click on the “Symbol” drop-down list, scroll down to the “Euro” options and select one, depending on whether you want the Euro symbol before or after the number. Click “OK”.

在“数字”选项卡上，应在“类别”列表中选择“货币”。 单击“符号”(Symbol)下拉列表，向下滚动至“欧元”(Euro)选项，然后选择一个，具体取决于您要在数字之前还是之后使用欧元符号。 点击“确定”。

The selected numbers now have a different currency symbol applied to them.

现在，所选数字已应用了不同的货币符号。

You may have noticed a drop-down list in the “Number” section of the “Home” tab that has a currency symbol on it. This may seem like an easier way to change the currency symbol for the selected cells. However, this is the “Accounting Number Format”, not the standard currency format.

您可能已经注意到“主页”选项卡的“数字”部分中的下拉列表上有货币符号。 这似乎是更改所选单元格的货币符号的更简单方法。 但是，这是“帐号格式”，而不是标准货币格式。

If you select “Euro” from the “Accounting Number Format” drop-down list…

如果您从“帐号格式”下拉列表中选择“欧元”…

…you’ll get Euro symbols on your numbers, but they will display in the accounting format, which aligns the decimal points in a column. Notice that the currency symbols are not right next to the numbers. Instead, they are left-aligned.

…您的数字上会得到欧元符号，但它们将以会计格式显示，该格式将一列中的小数点对齐。 请注意，货币符号不在数字旁边。 相反，它们是左对齐的。

You can also change the number of decimal places and the format of negative numbers on the “Number” tab on the “Format Cells” dialog box.

您还可以在“设置单元格格式”对话框的“数字”选项卡上更改小数位数和负数格式。

翻译自: https://www.howtogeek.com/240316/how-to-change-the-currency-symbol-for-certain-cells-in-excel/