How to play RMB currency symbol in Excel2010?

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.