Capitalization of English 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
it's very simple. It's the key to change the input method. You can hold down the key for a few seconds and change to digital input method
To use the "user-defined function" of converting numbers to English currency capitalization, the specific use method is as follows:
required materials: Excel, user-defined function of converting numbers to English currency capitalization (can be copied and pasted through the network)
First, open excel file, press Alt + F11 to open VBA window, insert a "mole"710480 is:
seven hundred and ten thousand and four hundred and eight~
if you have legal questions in the future, it is recommended that you use legal partners or download their lawyer's app for online consultation.