WPS changes numbers into money
Publish: 2021-05-16 14:23:23
1.
The number in excel is changed into currency "#" format mostly e to the use of other formats, which can be changed back to numerical value or conventional. The specific steps are as follows:
required materials: Excel
First, open the excel file and select the number cell in currency format
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.
By default, all cells are locked. To unlock all cells, lock only the fixed cells
6.
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
7. Set the cell format to currency format. Right click the cell -- cell format -- number format -- currency format
8. Right click the cell, select cell format, and select currency style
9. 假设：原始数据在B16单元格中
用以下公式
=IF(INT(B16)=0,"",TEXT(INT(B16),"[DBNum2]")&"元")&IF(OR(INT(B16*10)=0,INT(B16)=B16),"",IF(INT(B16*10)=INT(B16)*10,"零",RIGHT(TEXT(INT(B16*10),"[DBNum2]"),1)&"角"))&IF(INT(B16*100)=INT(B16*10)*10,"整",RIGHT(TEXT(ROUND(B16,2),"[DBNum2]"),1)&"分")
用以下公式
=IF(INT(B16)=0,"",TEXT(INT(B16),"[DBNum2]")&"元")&IF(OR(INT(B16*10)=0,INT(B16)=B16),"",IF(INT(B16*10)=INT(B16)*10,"零",RIGHT(TEXT(INT(B16*10),"[DBNum2]"),1)&"角"))&IF(INT(B16*100)=INT(B16*10)*10,"整",RIGHT(TEXT(ROUND(B16,2),"[DBNum2]"),1)&"分")
Hot content