Capitalization of digital currency
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.
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"
The standard words of RMB in capital:
one, two, three, four, five, six, seven, eight, nine, ten, ten, ten, ten, ten, ten, ten, ten thousand, hundred million, yuan, Jiao, Fen, zero, whole (positive)
Annex I of the people's Bank of China's settlement and payment measures: basic provisions for correctly filling in bills and settlement vouchers
Bank All kinds of bills and settlement vouchers filled in by units and indivials are the important basis for handling payment settlement and cash receipt and payment, which is directly related to the accuracy, timeliness and safety of payment settlement. Bills and settlement vouchers are the accounting vouchers used by banks, units and indivials to record accounts. They are a kind of written proof to record economic business and clarify economic responsibilities. Therefore, to fill in bills and settlement vouchers, we must be standardized and standardized, with complete elements, correct numbers, clear handwriting, good omission and no scribble, so as to prevent alteration
1. In Chinese, the amount in words should be filled in block letters or running script, such as one (one), two (two), three, four (four), five (five), six (six), seven, eight, nine, ten, million, ten thousand, ten thousand, hundred million, yuan, Jiao, Fen, zero and whole. It is not allowed to use one, two (two), three, four, five, six, seven, eight, nine, ten, Nian, Mao, another (or 0) to fill in, and it is not allowed to make simplified words. If the amount of figures written in traditional Chinese characters, such as two, six, billion, million, yuan, should also be accepted
2. If the amount in Chinese is up to yuan, the whole (or positive) words should be written after yuan, and the whole (or positive) words may not be written after Jiao. If the amount in words is divided, the whole (or positive) words shall not be written after the points
3. The amount in words in Chinese should be marked with the words of RMB, and the amount in words should be filled in immediately after the words of RMB, and there should be no blank. If RMB is not printed before the amount in words, three words of RMB shall be added. Fixed words of thousand, hundred, hundred, ten thousand, thousand, Bo, Shi, yuan, Jiao and Fen shall not be pre printed in the capital amount column of bills and settlement vouchers
4. When there is 0 in Arabic small amount, Chinese capital should be written in accordance with the rules of Chinese language, the composition of amount and number and the requirements of preventing alteration
5. In front of the Arabic small amount figures, the sign ￥ (or initialed:) should be filled in. The Arabic figures in figures should be filled in carefully, and should not be hyphenated and indistinguishable
6. The date of the bill must be written in Chinese. In order to prevent the alteration of the date of issue, when filling in the month and day,
(1) if the month is one, two and ten, and the day is one to nine and ten, twenty and three, zero should be added before it
(2) if the date is from eleven to nineteen, one shall be added before it. For example, January 15 should be written as January 15. Another example is October 20, which should be written as October 20
7. If the date of issue of the bill is written in lowercase, the bank will not accept it. If the date in words is not filled in according to the requirements, the bank may accept it, but if the losses are caused, the drawer shall bear the losses by himself
< H2 > reference materials: settlement and payment method - People's Bank of China
The amount in Chinese words shall be filled in block letters or running script, such as one, two, three, four, five, six, seven, eight, nine, ten, million, ten million, yuan, Jiao, Fen, zero, whole (positive), etc. It is not allowed to use one, two (two), three, four, five, six, seven, eight, nine, ten, twenty, Mao, another (or 0) to fill in, and it is not allowed to make simplified words. If traditional characters such as two, six, hundred million, ten thousand and Yuan are used in the amount figure writing, it is also acceptable
Chinese amount in words to & quot; Yuan & quot; Up to now, in & quot; Yuan & quot; After that, you should write & quot; Integer & quot Or & quot; Positive & quot;) Word, in & quot; Angle & quot; After that, you can not write & quot; Integer & quot Or & quot; Positive & quot;) Words. The amount in words is & quot; Score & quot; It's a good idea; Score & quot; Don't write & quot; Integer & quot Or & quot; Positive & quot;) Words
the amount in Chinese words should be marked with & quot; RMB & quot; Words, amount in words and figures are & quot; Score & quot; It's a good idea; Score & quot; Don't write & quot; Integer & quot Or & quot; Positive & quot;) Words
the amount in Chinese words should be marked with & quot; RMB & quot; Words, amount in words and figures should be followed by & quot; RMB & quot; The words shall be filled in without blank. Amount in words not printed before figures & quot; RMB & quot; If there is a word in it, it should be added with & quot; RMB & quot; Three words. Fixed & quot shall not be pre printed in the capital amount column of bills and settlement vouchers; Thousand, hundred, ten thousand, thousand, hundred, ten thousand, yuan, Jiao, Fen & quot; Words
The article "the origin of capital figures" published by Mr. Hou Jialiang in the 12th issue of "biting words" in 2004 says as follows: "in order to fight against corruption and build a clean government, Zhu Yuanzhang also formulated strict laws and regulations to punish economic crimes, carried out technical prevention in financial management, and implemented some effective measureschanging the Chinese characters' one, two, three, four, five, six, seven, eight, nine, ten, hundred and thousand 'to capitals, and using' one, two, three, four, five, six, seven, eight, nine, ten, hundred and thousand 'is one of the important ones. " That is to say, counting with capital numbers originated from Zhu Yuanzhang, the emperor of Ming Dynasty
If the amount in Chinese is up to "Yuan", the word "whole" (or "positive") shall 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"
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
the issue date of the bill must be capitalized in Chinese. In order to prevent the alteration of the issue date of the bill, if the month, day, hour, month are one, two and ten, the days are one to nine and ten, two and thirty, the word "zero" should be added before it, and if the day is eleven to nineteen, the word "one" should be added before it. For example, January 15 should be written as zero, one and fifteen, For another example, October 20 should be written as October 20
extended data
"Yuan" originated from silver yuan, because silver yuan is round, a piece of silver yuan is called one yuan. Later, because Yuan characters are easier to write than round characters, we all wrote yuan characters. In fact, it's a white character. However, because it was widely used, dictionaries were forced to admit it later. Therefore, the authentic should also be "round"
The Chinese character yuan is used to represent the unit of money. Yuan, in Chinese, has the original meaning and a general meaning. For example, yuan in "one yuan starts again and everything is renewed". Yuan is the unit of money, but money comes from social wealth and represents social wealth. Money is accompanied by proction and exchangeHow many yuan in words is the whole yuan: circle
extended materials:
the use of capital figures began in the Ming Dynasty
Zhu Yuanzhang issued a decree because of a major corruption case "Guo Huan case" at that time, which clearly required that the number of bookkeeping must be changed from "one, two, three, four, five, six, seven, eight, nine, ten, hundred, thousand" to "one, two, three, four, five, six, seven, eight, nine, ten, hundred (MO), thousand (Qian)" and other complex Chinese characters, To make it more difficult to alter the account books
Later, "Mo" and "Qian" were rewritten as "Bai, Qian" and have been used up to nowthe amount in Chinese 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, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten, ten
it is not allowed to use one, two (two), three, four, five, six, seven, eight, nine, ten, twenty, Mao, another (or 0), and it is not allowed to make simplified words
if traditional characters such as Er, Lu, Yi, Wan and Yuan are used in the amount figure writing, it is also acceptable
Chinese amount in words to & quot; Yuan & quot; Up to now, in & quot; Yuan & quot; After that, you should write & quot; Integer & quot Or & quot; Positive & quot;) Word, in & quot; Angle & quot; After that, you can not write & quot; Integer & quot Or & quot; Positive & quot;) Words
the amount in words is & quot; Score & quot; It's a good idea; Score & quot; Don't write & quot; Integer & quot Or & quot; Positive & quot;) Words
the amount in Chinese words should be marked with & quot; RMB & quot; Words, amount in words and figures are & quot; Score & quot; It's a good idea; Score & quot; Don't write & quot; Integer & quot Or & quot; Positive & quot;) Words
the amount in Chinese words should be marked with & quot; RMB & quot; Words, amount in words and figures should be followed by & quot; RMB & quot; The words shall be filled in without blank
the amount in words is not printed before the figure & quot; RMB & quot; If there is a word in it, it should be added with & quot; RMB & quot; Three words