Convert numbers into capital letters
Publish: 2021-04-15 15:55:55
1. =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;]
2.
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
3. 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.
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.
4. 1. Baosteel Special enamel plate is the most important material of enamel liner. The quality of steel plate must be selected according to the requirements of forming (deformation, welding, etc.), enameling process and enamel procts. The expansion coefficient of enamel is 32 × 10-7
the carbon content of the selected plate is ≤ 0.08%. The yield limit and strength limit of the steel are increased, but the elongation is decreased when the steel contains appropriate amount of manganese. Therefore, the higher the manganese content, the greater the deformation force required
for carbon steel, silicon and manganese are the resies of deoxidizer ring smelting. In general, silicon content & lt; 0.37% of the steel plate can be used for deep drawing, but beyond this value, even the steel with low carbon content will become hard and brittle, which is not suitable for deep drawing and affects the sealing performance. The existence of sulfide will affect the microstructure of steel plate to a great extent, promote the generation of stripe structure, and rece the plasticity and toughness of finished steel, that is, rece the drawing performance of finished steel, and bubbles and pores will appear in the porcelain layer. Phosphorus dissolved in ferrite can significantly rece the plasticity of finished steel, but improve its strength and hardness; 0.06% Titanium added to steel is very beneficial to enamel. Because it can combine with various components in enamel and increase the density, Baosteel Special enamel plate BTC 330r is the most ideal base material for enamel liner
2. The water tank is just a popular hemispherical pressure head
the pressure tank head is made of 2mm thick special enamel steel plate. The hemispherical shape of the maximum limit should be achieved in the design, so that the bearing capacity and fatigue resistance can reach the best. To ensure the minimum deformation of enamel water tank after long-term use, so as to extend the service life of enamel water tank. When the pressure is 1.5 times of the rated pressure, the times of pressure can reach 300000
3. Structural characteristics of the tank
the tank adopts double flange structure, which solves the hidden trouble of pool coating quality caused by the failure to grind the welded joint before pool coating; The butt welding method of head and barrel body can avoid bubble ring pool coating by conventional lap welding method; The special water tank fixed belt can solve the hidden trouble of enamel liner damage caused by long time suspension of water tank; The special enamel electric heating can solve the problems of low heating efficiency, waste of resources and hidden danger of safety after the common electric heating is attached with scale; The bending welding method of the medium water nozzle solves the problem of poor medium flow in the past right angle welding.
the carbon content of the selected plate is ≤ 0.08%. The yield limit and strength limit of the steel are increased, but the elongation is decreased when the steel contains appropriate amount of manganese. Therefore, the higher the manganese content, the greater the deformation force required
for carbon steel, silicon and manganese are the resies of deoxidizer ring smelting. In general, silicon content & lt; 0.37% of the steel plate can be used for deep drawing, but beyond this value, even the steel with low carbon content will become hard and brittle, which is not suitable for deep drawing and affects the sealing performance. The existence of sulfide will affect the microstructure of steel plate to a great extent, promote the generation of stripe structure, and rece the plasticity and toughness of finished steel, that is, rece the drawing performance of finished steel, and bubbles and pores will appear in the porcelain layer. Phosphorus dissolved in ferrite can significantly rece the plasticity of finished steel, but improve its strength and hardness; 0.06% Titanium added to steel is very beneficial to enamel. Because it can combine with various components in enamel and increase the density, Baosteel Special enamel plate BTC 330r is the most ideal base material for enamel liner
2. The water tank is just a popular hemispherical pressure head
the pressure tank head is made of 2mm thick special enamel steel plate. The hemispherical shape of the maximum limit should be achieved in the design, so that the bearing capacity and fatigue resistance can reach the best. To ensure the minimum deformation of enamel water tank after long-term use, so as to extend the service life of enamel water tank. When the pressure is 1.5 times of the rated pressure, the times of pressure can reach 300000
3. Structural characteristics of the tank
the tank adopts double flange structure, which solves the hidden trouble of pool coating quality caused by the failure to grind the welded joint before pool coating; The butt welding method of head and barrel body can avoid bubble ring pool coating by conventional lap welding method; The special water tank fixed belt can solve the hidden trouble of enamel liner damage caused by long time suspension of water tank; The special enamel electric heating can solve the problems of low heating efficiency, waste of resources and hidden danger of safety after the common electric heating is attached with scale; The bending welding method of the medium water nozzle solves the problem of poor medium flow in the past right angle welding.
5. How much RMB does a l d equal? It depends on the international exchange rate on that day?
6. =SUBSTITUTE(IF(A1>- 0.5%," 12367""& TEXT(INT(FIXED(ABS(A1)), "[ dbnum2]G/36890;-29992;-26684;-24335;-20803;&& quot;& TEXT(RIGHT(FIXED(A1),2),"[ dbnum2]035282;/020998;& quot;& IF(ABS(A1)> 1%, " .25972;quot;] quot; (38646;)35282", IF(ABS(A1)< 1," 38646,"] quot; .38646;. quot; 25972;quot;< br />
26356;<31526;<21512;<36135;<24065;<20889;>30340; <27714;65292;32780;<19988;>36229;<25968;<20063;<20063;>19981;<20925025338
26356;<31526;<21512;<36135;<24065;<20889;>30340; <27714;65292;32780;<19988;>36229;<25968;<20063;<20063;>19981;<20925025338
7.
Here, taking Office Excel 2013 version as a specific example, the operation method of converting numbers to RMB capitalization in excel is as follows:
1. Enter the excel table, select the table, right-click the cell, and select set cell format on the pop-up page
8. "25226;" 24065;"20889021150;" br />20551;"2291414;" 25454;"A21015B136755;" br />=IF(A1=0,""" quot; IF(A1< 0," "" quot; quot; SUBSTITUTES(SUBSTITUTES(INT(ABS(A1),"[ DBNum2]"& quot; " SUBSTITUTES(TEXT(RIGHT(A1*100,2),"[ DBNum2 quot; "" quot; "" quot; "" quot; "" quot; """ quot; """ quot; "" quot; "))
9. 用NUMBERSTRING函数
如：将A2单元格的531转换成大写，则公式
=NUMBERSTRING(A2,2)：此时得出：伍佰叁拾壹
=NUMBERSTRING(A2,1)：此时得出：五百三十一
=NUMBERSTRING(A2,3)：此时得出：五三一
如要将数字读出：则用此公式
=IF(ISERROR(FIND(".",A2)),NUMBERSTRING(INT(A2),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(A2,FIND(".",A2)+2,1),2)),NUMBERSTRING(INT(A2),2)&"元"&NUMBERSTRING(MID(A2,FIND(".",A2)+1,1),2)&"角整",NUMBERSTRING(INT(A2),2)&"元"&NUMBERSTRING(MID(A2,FIND(".",A2)+1,1),2)&"角"&NUMBERSTRING(MID(A2,FIND(".",A2)+2,1),2)&"分"))
如：将A2单元格的531转换成大写，则公式
=NUMBERSTRING(A2,2)：此时得出：伍佰叁拾壹
=NUMBERSTRING(A2,1)：此时得出：五百三十一
=NUMBERSTRING(A2,3)：此时得出：五三一
如要将数字读出：则用此公式
=IF(ISERROR(FIND(".",A2)),NUMBERSTRING(INT(A2),2)&"元整",IF(ISERROR(NUMBERSTRING(MID(A2,FIND(".",A2)+2,1),2)),NUMBERSTRING(INT(A2),2)&"元"&NUMBERSTRING(MID(A2,FIND(".",A2)+1,1),2)&"角整",NUMBERSTRING(INT(A2),2)&"元"&NUMBERSTRING(MID(A2,FIND(".",A2)+1,1),2)&"角"&NUMBERSTRING(MID(A2,FIND(".",A2)+2,1),2)&"分"))
10. Select the area, click Format - cell - number - special in the menu bar, and change it to Chinese capital number.
Hot content