WPS converts numbers into capital currency
right click to set the cell format, as shown in the figure below
select "number" -- "numerical value", and set it as you want
用以下公式
=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)&"分")
1. First, you need to find and select the cell in which the amount is written in the WPS table
1. Double click the left mouse button on the WPS table icon on the computer desktop to open it and run it. And open the worksheet file to edit or modify
in the number tab of the pop-up window, select "RMB capitalization" in the "special" category, and click "OK"
the conversion effect of RMB capitalization in WPS table is shown in the figure below, isn't it very convenient?
1. Select a cell and press Ctrl + 1 to open the cell Format dialog box
2. In the "number" tab, select "post" and Chinese uppercase.
Cell format modification
20511;.35774;.25968;<22312;<1/p><
<30452; <25509;<30452>B131896;>36148;<27492;<2044;<24335p>=SUBSTITUTE(IF(A1<); 0," .36127"" quot;& quot;& amp; TEXT(TRUNC(ABS(ROUND(A1,2)), "[ DBNum2]"& amp;& quot; .20803"& amp; IF(ISERR(FIND(") quot;, ROUND(A1,2)), "& quot;, TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)), "[ DBNum2]"] amp; IF(ISERR(FIND(") 0", TEXT(A1," 0.00"] quot; .35282"& quot;& quot;& amp; IF(LEFT(RIGHT(ROUND(A1,2),3)); quot;, TEXT(RIGHT(ROUND(A1,2)), "[ DBNum2]"& amp;& quot; .20998;quot;, IF(ROUND(A1,2)=0,"& quot;& quot; .25972"] quot; .38646;. quot;& quot;,& quot; .38646;. quot; 38646;quot;
{RRR}