WPS currency figures
Publish: 2021-03-25 08:46:25
1. Word pure blank file is not good, to be able to operate under the spreadsheet to display currency figures, otherwise you have to type a few decimal places. You can insert a spreadsheet in word (it's not good to insert a spreadsheet either) in the shortcut toolbar insert a spreadsheet enter the number you want select the cell you want to change right click Set cell format number currency change the number of decimal places you want to keep. Or directly use Excel (electronic form) to operate the same as above, right-click the cell to be transformed, and click Set cell format - number - currency - OK. Now the next version of WPS 2010, the function is also very good yo. Give the owner a WPS download link: http://xiazai.zol.com.cn/detail/9/88682.shtml If you have time to be familiar with the WPS operation, it will bring you a lot of convenience.
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. 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
4. 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
5. 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.
6.
In the Insert menu symbol toolbox, as shown in the figure:
7.
By default, all cells are locked. To unlock all cells, lock only the fixed cells
8. You need to select a column before setting it to currency format.
right click cell format currency type
right click cell format currency type
9.
Here is an operation flow of word number to currency format:
required materials: this method is only applicable to the numbers in the table
1. As shown in the figure below, the numbers are listed on the left. Click the first cell on the top right to enter the "layout" menu
10. Debug the width of the data column
if not very strict, you can use text format instead< br />
Hot content