The method of currency numeral capitalization conversion
Publish: 2021-04-17 04:36:45
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.
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. 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"
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"
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. General br/> int m1,m2,m3,m4.m5,m6,temp;
m1 =temp%1000000/100000;< br/> m2 =temp%100000/10000;< br/> m3 =temp%10000/1000;< br/> m4 =temp%1000/100; < br/> m5 =temp%100/10; < br/> m6 =temp%10; < br />
> char c1,c2,c3,c4,c5,c6; < br/> c1=transe(m1);< br/> c2=transe(m2);< br/> c3=transe(m3);< br/> c4=transe(m4);< br/> c5=transe(m5);< br/> c6=transe(m6);< br/> String str="" < br/ > if (m1!= 0)
{
str+=c1+& Organisation br/> }
if (m2!= 0)
{
str+=c2+& Cannot initialise Evolution's mail component. br/> }
if (m1!= 0 & &m2 = 0 &(m3!= 0. (m4!= 0))
str+=& Organisation br/> }
if (m3!= 0)
{
str+=c3+& Organisation br/> }
if (m2!= 0 & &m3 = 0 & &m4!= 0)
{
str+=" Organisation br/> }
if (m4!= 0)
{
str+=c4;< br/> }
str+=& Organisation br/> if (m5 ==0 & &m6 ==0)
str+=" Organisation br/> }
if (m5!= 0)
{
str+=c5+& Organisation br/> }
if (m5==0 & &m6!= 0)
{
str+=" Organisation br/> }
if (m6!= 0)
{
str+=c6+& Organisation br/> }
System.out.print(str+"&# 92; n ";< Browse quot;);< br/>
}
public static char <39;< br/> switch (m)
< r = & #39; 0' < br/> < break;
< r = & #39; [UNK]22777;'< br/ > < break; < br/ > =case 2:
= & #39; [UNK]36144;'< br/> < break;< br/ > =case 3:
= & #39; 0121441;'< br/> < break;< br/ > =case 4:
= & #39; Boundary ' < br/> < break;< br/ > =case 5:
=r = & #39; 39;< br/> < break;< br/ > =case 6:
= & #39; Land ' < br/> < break;< br/ > =case 7:
=r = & #39; < br/> < break;< br/ > =case 8:
=r = & #39; < br/> < break;< br/ > =case 9:
= & #39; [UNK]29590;'< br/> < break;< br/>
}
< return r;< br/> }
}
m1 =temp%1000000/100000;< br/> m2 =temp%100000/10000;< br/> m3 =temp%10000/1000;< br/> m4 =temp%1000/100; < br/> m5 =temp%100/10; < br/> m6 =temp%10; < br />
> char c1,c2,c3,c4,c5,c6; < br/> c1=transe(m1);< br/> c2=transe(m2);< br/> c3=transe(m3);< br/> c4=transe(m4);< br/> c5=transe(m5);< br/> c6=transe(m6);< br/> String str="" < br/ > if (m1!= 0)
{
str+=c1+& Organisation br/> }
if (m2!= 0)
{
str+=c2+& Cannot initialise Evolution's mail component. br/> }
if (m1!= 0 & &m2 = 0 &(m3!= 0. (m4!= 0))
str+=& Organisation br/> }
if (m3!= 0)
{
str+=c3+& Organisation br/> }
if (m2!= 0 & &m3 = 0 & &m4!= 0)
{
str+=" Organisation br/> }
if (m4!= 0)
{
str+=c4;< br/> }
str+=& Organisation br/> if (m5 ==0 & &m6 ==0)
str+=" Organisation br/> }
if (m5!= 0)
{
str+=c5+& Organisation br/> }
if (m5==0 & &m6!= 0)
{
str+=" Organisation br/> }
if (m6!= 0)
{
str+=c6+& Organisation br/> }
System.out.print(str+"&# 92; n ";< Browse quot;);< br/>
}
public static char <39;< br/> switch (m)
< r = & #39; 0' < br/> < break;
< r = & #39; [UNK]22777;'< br/ > < break; < br/ > =case 2:
= & #39; [UNK]36144;'< br/> < break;< br/ > =case 3:
= & #39; 0121441;'< br/> < break;< br/ > =case 4:
= & #39; Boundary ' < br/> < break;< br/ > =case 5:
=r = & #39; 39;< br/> < break;< br/ > =case 6:
= & #39; Land ' < br/> < break;< br/ > =case 7:
=r = & #39; < br/> < break;< br/ > =case 8:
=r = & #39; < br/> < break;< br/ > =case 9:
= & #39; [UNK]29590;'< br/> < break;< br/>
}
< return r;< br/> }
}
7. When we use Excel to make accounts, we often use Chinese capital to express the currency. Copy the following formula to the cell, and enter the currency number in cell A1. The cell in which the formula is located will be automatically converted to the capital Chinese currency form, which is very easy to use. In practice, A1 in the formula can be changed to any specified cell< br />＝SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[ Dbnum2] g / general format element; Negative [dbnum2] g / general format element& quot;& IF(A1>- 0.5%,," Negative & quot;))& TEXT(RIGHT(FIXED(A1),2),"[ Dbnum2] 0 Jiao 0 min& quot;& IF(ABS(A1)> 1%," Integer & quot;,)& quot; Zero angle;, IF(ABS(A1)< 1,," Zero & quot;)& quot; Zero & quot& quot; Integer (& quot;)
refer to blog articles: http://mymz.blog.hexun.com/24997382_ d.html
refer to blog articles: http://mymz.blog.hexun.com/24997382_ d.html
8. In fact, you don't need any software. This can be done through Excel.
to convert RMB small amount into capital format, use the format provided by Excel to change "[dbnum2] g / general format" in the custom format type to "[dbnum2] g / general format" Yuan ". However, there are some problems in the conversion of decimals. For example, ￥ 6050.09 can only be converted to ￥ 60050.09. Can excel solve this inborn problem? There are the following two methods (both of them are converted to B1, assuming that B1 is a small amount of two decimal places obtained by rounding function round (), and its value is ￥ 6050.09)< In B2, enter the formula "= if (B1 〈 0, & quot; Negative amount is invalid & quot;, Int (B1)), the calculation result is ￥ 6050.00, then click "format → cell → number → special → Chinese capital number → OK", B2 displays "six thousand and fifty", and then click "format → cell → number → custom", change "[dbnum2] g / general format" in "type" edit box to: [dbnum2] ("RMB") g / general format "Yuan", At this time, B2 displays: "RMB six thousand and fifty"
2. Enter "= if (B1 ＜ 0, & quot& quot;， INT(B1
to convert RMB small amount into capital format, use the format provided by Excel to change "[dbnum2] g / general format" in the custom format type to "[dbnum2] g / general format" Yuan ". However, there are some problems in the conversion of decimals. For example, ￥ 6050.09 can only be converted to ￥ 60050.09. Can excel solve this inborn problem? There are the following two methods (both of them are converted to B1, assuming that B1 is a small amount of two decimal places obtained by rounding function round (), and its value is ￥ 6050.09)< In B2, enter the formula "= if (B1 〈 0, & quot; Negative amount is invalid & quot;, Int (B1)), the calculation result is ￥ 6050.00, then click "format → cell → number → special → Chinese capital number → OK", B2 displays "six thousand and fifty", and then click "format → cell → number → custom", change "[dbnum2] g / general format" in "type" edit box to: [dbnum2] ("RMB") g / general format "Yuan", At this time, B2 displays: "RMB six thousand and fifty"
2. Enter "= if (B1 ＜ 0, & quot& quot;， INT(B1
Hot content