WPS table Easy to complete the currency conversion of numbers

Source: Internet
Author: User

Excel tables often deal with numbers, and in fact, Excel can be a great convenience for our work, but it needs to be explored in a step-by-step way.

Today, MO introduced to you how to use the WPS Mobile version to achieve the conversion between the number and currency. We can type a number to do the overall conversion, you can also set the cell, and directly type the currency number, come and learn with Mo!

If you get a table, you need to change the text number to a currency number, first you need to select the column number. and click cell Formatting in the toolbar, and then set the settings in the window: "category" is set to "currency" and set the number of digits after the decimal point, as well as the currency symbol, you can.

The method is also simple if you want to display a currency symbol while typing a number. The currency numbers are automatically generated when you first select the blank column and format the cell, and then type the number. Is it convenient? The figures in the table have all become renminbi currency, which looks too comfortable.

WPS Mobile version is the Golden Hill Office software launched, running on the Android platform full-featured Office software, support to view, create and edit a variety of commonly used Office documents, user-friendly mobile phones and tablets to meet the needs of users anywhere, the office, so that the user's Office document operations in control.

Note : More attention to the computer Tutorials section, triple Computer office group: 189034526 welcome you to join

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.