How to play RMB currency symbol in Excel2010?

How to play RMB currency symbol in Excel2010?

How to play the currency symbol of RMB

In Excel, for example, first enter the number "58" in the cell, and then click the Currency command in the number Drop-down list on the Start tab, which is automatically displayed as currency, in a way that you can set the entire row or column as currency. Of course, if you only need to enter the RMB symbol in Word or Excel by using the full angle Chinese input 4/$ This key will automatically display the ￥ symbol, you can also use the caret way to enter the currency symbol.

Second, Excel changes the default currency format

In Excel, sometimes it is not necessary to use the renminbi symbol, may be used in other currency symbols, then we can change the default currency format, the following steps:

1, click the Start menu on the desktop, click Settings-Control Panel command in the list

Excel2010

2, and then open the Regional and Language Options dialog box, click the Customize button on the Regional Options tab.

3, open the Custom Regional Options dialog box, click the Currency tab, select the currency you want to change in the currency symbol list, and the scale can be set according to your needs.

Excel2010

4, then return to Excel to set the cell in currency format, then it will become you set the default currency format.