Convert digital currency to uppercase

1. Right click "user defined cell format" = =, special = =, Chinese capitalization
if you are not satisfied, try this:
= numberstring (1234567890,1)
parameter 1 can be modified, 123456.. is a hypothetical number, which can be changed to cell name
if not, try this:
= subordinate (text (fixed (A1)), & quote[& gt; 0][dbnum2];[& lt; 0] negative [dbnum2]& quot;)& TEXT(RIGHT(FIXED(A1),2)," Yuan [dbnum2] 0 Jiao 0 fen& quot;& IF(ABS(A1)> 1%," Yuan integer & quot;,)& quot; Zero angle;, IF(ABS(A1)< 1,," Zero & quot;)& quot; Zero & quot& quot; Integer (& quot;)
where A1 is the cell of hypothetical data.

2. =TEXT(RMB(A1), "[] g& quot;& TEXT(INT(ABS(A1)+0.5%), "[ dbnum2]G/36890;-29992;-26684;-24335;-20803;&& quot;& SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A1),2),"[ dbnum2]035282;020998;; .25972;quot;," quot; (38646;)35282", IF(A1^2< 1," 38646,"] quot; .38646;. quot; 25972;quot;]

3. This is easier! Suppose it's 23.68 yuan, select this cell - right click - set cell format - Special - Chinese capital number (on the right)

4. The initials of bitcoin are used to represent the concept of bitcoin or the whole bitcoin network itself. For example: "today I learned something about the bitcoin agreement."

a bitcoin without capital letters indicates a unit of account. For example: "I transferred 10 bitcoin today." The unit is also usually abbreviated as BTC or XBT

the abbreviation of Leyte coin is "LTC"

5.

We all know that excel can do a lot of accounting work, and there are many excel tips. Today, we will learn how to convert currency numbers into capital letters in Excel. The specific methods are as follows:

1. Select E11, F11 and G11 cells respectively, and input the common expressions in turn: = text (int (ABS (C10)), & quot[ Dbnum2] g / general format & quot;)= TEXTINTABSC10*10-INTABSC10*10,"[ Dbnum2] g / general format & quot;)= TEXTINTABSC10*100 -INTABSC10*10*10,"[ Dbnum2] g / general format & quot;). The meaning of the above formula is to determine the values of yuan, Jiao and Fen of the statistical results and convert them into Chinese capital format

2. Select E10 cell and input formula: = D11 & amp; E11&& quot; Yuan & quot& amp; F11&& quot; Angle & quot& amp; G11&& quot; Score & quot; Or = concatenate (D11, E11, & quot; Yuan & quot;, F11," Angle;, G11, " Score & quot;). The meaning of the above formula is: combine the text in cells D11 to G11 into a whole, and add the unit & lt; Yuan, Jiao, Fen & quot; Words

3. Left click the line label of 11 lines, select the line, right-click the mouse, and select & lt; Hide & quot; Option to hide 11 lines without affecting normal printing. At this point, the conversion work is over, and the effect is as shown in the figure

the above is our method of converting currency numbers into capital letters in Excel. You can use it according to your own needs, and you can also find more tips according to your own intelligence

6. Select currency in setting cell format. If you want to convert to uppercase, select special Chinese
uppercase number

7. < UL >

Open excel. For the convenience of explanation, two columns are established here, as shown in the figure

< / UL >

8. Use Excel to right-click the shortcut menu in the cell where you want to enter numbers, select "set cell format", select Chinese capital numbers (there are two, the second is traditional) in "special" under the "number" option, and click "confirm"
Arabic numerals are international common numbers nowadays. It was first invented by Indians, then spread to Europe by Arabs, and then modernized by Europeans. Because of the spread of Arabs, it became the key node for the number to be used internationally, so people called it "Arabic numeral" (it can also be said that people mistakenly called it Arabic numeral)
Arabic numerals are composed of 10 counting symbols: 0, 1, 2, 3, 4, 5, 6, 7, 8 and 9. Take the bit value method, high in the left, low in the right, from left to right writing. With the help of some simple mathematical symbols (decimal point, minus sign, percent sign, etc.), this system can clearly represent all rational numbers. In order to represent the maximum or minimum number, people created the scientific notation on the basis of Arabic numerals
in Chinese, the amount in words should be filled in block letters or running script, such as one, two, three, four, five, six, seven, eight, nine, ten, ten, ten, ten, ten thousand, hundred million, yuan, Jiao, Fen, zero, whole (positive), not in one, two (two), three, four, five, six, seven, eight, nine, ten, Mao, another (or 0), and not in simplified words. If the amount of figures written in traditional Chinese characters, such as two, six, billion, million, yuan, should also be accepted

the following should also be noted in the correct writing of RMB in words:

1. If the amount in words in Chinese is up to "Yuan", the word "whole" (or "positive") should be written after "Yuan"; After "Jiao", the word "Zheng" (or "Zheng") may not be written; If the amount in words has "Fen", the word "whole" (or "positive") shall not be written after "Fen"

2. In Chinese, the words "RMB" should be indicated before the amount in words, and the amount in words should be filled in immediately after the words "RMB", and no blank space should be left. If the words "RMB" are not printed before the amount in words, the three words "RMB" shall be added, and the fixed words "thousand, hundred, hundred, ten thousand, thousand, hundred, ten thousand, yuan, Jiao, Fen" shall not be pre printed in the amount in words column of bills and settlement vouchers.