If you want to convert the amount of a number into capital in Jiao Yuan cents (for example, "123.45" is converted into "122 yuan and 45 cents"), you can use the formula: = if ((a1-int (a1)) = 0, text (A65438+ ". if(int(a 1 * 10)-a 1 * 65433" Yuan " & amp TEXT((INT(a 1 * 10)-INT(a 1)* 10)，"[db num 2]" " & amp； "rounded corners", text (int (a 1), "[dbnum 2]"&" Yuan "& if (int (a1*10)-int (a1) *10 = 0," zero ",text (int (a1*/kloc-0. TEXT(RIGHT(A 1， 1)，"[db num 2]")& amp； "Points"))

I only have a similar and incomplete formula, = text (int (a 1), "[dbnum2] g/common format"), if I want to convert a number into a capital chinese numerals (for example, "123.45" is converted into "123.45"); Text (mod (a 1, 1) * 100, "dot [DBNum2]00") can only be converted to two decimal places, and the number of converted digits can't exceed one. If the number is too large, an error will occur.

In addition, you can also display Chinese in excel cell format, but only visually, and selective pasting can only copy numbers. Right-click-Format Cells-Classify (select "Special") and type (select "Chinese Capitalized Numbers").