How to set number and currency symbol in WPS table
Publish: 2021-03-31 09:38:15
1.
1. The computer opens the excel table and selects the data to be marked with currency
2.
-
select the number range to be changed
-
right click to set the cell format, as shown in the figure below
-
-
select "number" -- "numerical value", and set it as you want
3. Select the number range you want to change
right click to set the cell format, as shown in the figure below
select "number" -- "numerical value", and set it as you want
right click to set the cell format, as shown in the figure below
select "number" -- "numerical value", and set it as you want
4.
In the Insert menu symbol toolbox, as shown in the figure:
5.
By default, all cells are locked. To unlock all cells, lock only the fixed cells
6. You need to select a column before setting it to currency format.
right click cell format currency type
right click cell format currency type
7.
1. First, open the table to edit with Excel 2016 on the computer, and then find the data column to add the currency symbol
8.
1. First, open WPS office
9. Input method: switch to big Chinese, press and hold the shift key + number key 4 on the top of the keyboard
to input RMB symbol:￥
to input RMB symbol:￥
Hot content