WPS table digital currency
Publish: 2021-05-20 02:32:29
1.
-
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
2. Hello, WPS text, such an operation is not convenient
Convert to a table. In the insert table tool, the text is converted to a table
then, it to the WPS table, and it's easy to use sorting or filtering
after separation, it back from the table. Also use the table tool to convert the table to text
for more WPS office software tutorials, please visit: http://bbs.wps.cn perhaps http://e.weibo.com/wpswfw
Convert to a table. In the insert table tool, the text is converted to a table
then, it to the WPS table, and it's easy to use sorting or filtering
after separation, it back from the table. Also use the table tool to convert the table to text
for more WPS office software tutorials, please visit: http://bbs.wps.cn perhaps http://e.weibo.com/wpswfw
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. First set the cells to the currency format you want, and then enter the data. The method is: first select some cells or a column to be changed into currency format, then open the format menu, and set the cell format in currency on the number tab. If you don't have what you want, you can first select a similar one, and then click Custom to modify it.
5.
By default, all cells are locked. To unlock all cells, lock only the fixed cells
6. Debug the width of the data column
if not very strict, you can use text format instead< br />
7. Did you use a custom format to cancel the space in the middle
8. Right click the cell, select cell format, and select currency style
9. Select to format cells.
Hot content