Excel Small prize large Prize

Excel skills

Http://hi.baidu.com/sunway999

= If (INT (g16 * 10)-int (g16) * 10) = 0, text (INT (g16), "[dbnum2] g/common format ") & "Yuan" & if (INT (g16 * 100)-int (g16) * 10) * 10) = 0, "whole ", "Zero" & text (INT (g16 * 100)-int (g16 * 10) * 10, "[dbnum2] g/common format") & "points "), text (INT (g16), "[dbnum2] g/common format") & "meta" & if (INT (g16 * 100)-int (g16) * 10) * 10) = 0, text (INT (g16 * 10)-int (g16) * 10), "[dbnum2] g/common format") & "Corner ", text (INT (g16 * 10)-int (g16) * 10), "[dbnum2] g/common format ") & "" & text (INT (g16 * 100)-int (g16 * 10) * 10, "[dbnum2] g/common format") & "Minute "))

Method 1: use the formula

In my work, I often need to implement this function. In the past, manual conversion was required. In the past, I also found some small programs for conversion, however, it turns out garbled characters are displayed in small programs and copied to excel. Now, with this formula, you don't have to set your own functions, just copy and replace them directly. Great! In Excel, if A1 is a cell in digital format, paste the following formula into any cell to display a large fixed amount:

= If (A1 <= 0, text (INT (A1), "[dbnum2] RMB g/common format") & "Yuan" & if (INT (A1 * 10) -int (A1) * 10 = 0, if (INT (A1) * (INT (A1 * 100)-int (A1 * 10) * 10) = 0 ,"", "0"), text (INT (A1 * 10)-int (A1) * 10, "[dbnum2]") & "") & if (INT (A1 * 100)-int (A1 * 10) * 10) = 0, "integer", text (INT (A1 * 100) -int (A1 * 10) * 10), "[dbnum2]") & "points "))

 

Method 2: Cell format

You only need to set the cell to "special"-"uppercase Chinese numbers.