Tips for converting numbers and currencies in WPS tables

Time: 2022-06-14Source: Huajun Informationauthor:


If you get a table and need to change the text numbers into currency numbers, you first need to select the column of numbers. And click "Format Cells" in the toolbar, and then make relevant settings in the window: set the "Category" to "Currency", and set the number of digits after the decimal point and the currency symbol, and that's it.

cell format
cell format

If you want to display currency symbols while typing numbers, the method is also very simple. First select a blank column and set the cell format, then type in numbers and currency numbers will be automatically generated. Isn’t it very convenient? The numbers in the table have all been converted into RMB currency, which looks so comfortable.

The above is how to convert between numbers and currency in the WPS table. As long as you set the currency through the categories in the cell format, including the number of decimal points, currency symbols, etc., you can convert the numbers in the table into currency form. You know currency by looking at it.

Related articles更多>>

Popular recommendations