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 curre