What kind of currency symbol precedes the number

1. Set the cell format, change #, #, 0.00 to #, #, 0.00 ￥ in user-defined, and then set the cell to this format

2. Set the cell format, change #, #, 0.00 to #, #, 0.00 ￥ in user-defined, and then set the cell to this format

3.

The operation method of adding currency symbol to cells in excel is as follows:

1. first, select cells (such as m54), right-click the cell range, and select "set cell format"

2. next, click "number" -- "currency", select the corresponding currency symbol, such as "￥", and then click "OK"

   

3. finally, click "OK"< br />

4.

Put it in front of the numbers

the symbol of RMB is. The writing order is:

1. First write the capital letter "Y", then add two horizontal lines on the vertical line, that is "" and the pronunciation is: Yu á N (sound: yuan)

2. When filling in the amount in Arabic numerals in the form of filling in the amount one by one, a "" sign is added before the first place of the amount, which can not only prevent the number from being added before the amount, but also indicate the amount of RMB

3. Since "" itself represents the unit of RMB "Yuan", it is unnecessary to add "Yuan" after the amount if "" is added before the amount

for example, ￥ 6.318.06 means RMB 6318.06

extended materials:

China began to issue RMB on December 1, 1948, with "Yuan" as the unit, and the Chinese Pinyin of "Yuan" is yuan. Take the first letter of Yuan's Pinyin and add two horizontal lines to form "￥", which is defined as the symbol of RMB

when writing the amount in figures, there should be no space between the RMB symbol "￥" and the number to prevent the amount from being altered

When writing RMB symbol "￥", especially when cursive "￥", we should pay attention to the obvious difference between "￥" and Arabic numerals, especially not to be confused with 7 or 9 of Arabic numerals

as long as the RMB symbol "￥" is used to fill in bills (invoices, checks, certificates of deposit, etc.), ordinary people can not use the "￥" symbol when registering account books and preparing statements. Because using "￥" symbol on account book or report will increase the possibility of error

5. This is no good, especially in accounting, banking and other professional fields,

should meet the following requirements:

(1) Arabic numerals should be written one by one, and the currency symbol (such as RMB symbol "￥") or the abbreviation of currency name and the type of goods symbol should be written before the Arabic amount.  There shall be no blank space between currency symbol and Arabic amount number. Where the currency symbol is written in front of the Arabic amount number, the monetary unit (such as RMB "Yuan") will not be written after the number

(2) all Arabic numerals in yuan (other currencies are the basic monetary units, the same below), except for unit price, etc,  If there is no decimal point, it can be written with "00" or "-", if there is no decimal point, it should be written with "0" instead of "-"

(3) the amount of money in Chinese characters should be written in block letters or running script, such as one, two, three, four, five  Words such as six, seven, eight, nine, ten, ten, ten, ten, ten, ten thousand, hundred million, yuan, Jiao, Fen, zero, and Zheng that are easy to identify and not easy to alter shall not be replaced by simplified words such as 0, one, two, three, four, five, six, seven, eight, nine, ten, another, and Mao, and shall not be arbitrarily made by oneself< (4) if the amount in words is up to yuan or Jiao, the word "whole" or "positive" should be written after "Yuan" or "Jiao"; If the amount in words is divided, the word "whole" shall not be written after the words

(5) if the name of the currency is not printed before the amount in words, the name of the currency (such as "RMB") shall be added, and there shall be no blank between the name of the currency and the amount

(6) when there is "0" in the middle of Arabic amount, the amount in words should be written as "0", such as RMB 101.50,  The amount in Chinese characters shall be written as one hundred and one yuan and fifty cents only. When there are several "0" in the middle of Arabic amount, only one "0" can be written in Chinese capital amount, such as ￥ 1004.56,  The amount in Chinese characters should be written as one thousand four yuan and fifty-six cents. When the Arabic amount digit is "0", or there are several "0" in the middle of the digit, and the digit is also "0", but the angle is not "0", the amount in Chinese capital can be written with only one "zero" character, or it can not be written with "zero" character.

6. Right click the cell, set cell format, select currency, and select RMB symbol in currency symbol (country / region) on the right.

7. All of them need to be added, because it won't make people ambiguous
since 2013, the popular digital currencies include bitcoin, Ruitai coin, Laite coin, doggy coin, Ethereum, Yuanbao coin, etc.

8. First of all, fill in the date of collection
the receipt, and you will write the payment received from XX
the number in the grid should be preceded by the RMB symbol ￥
and then write the amount in capital
the payee's signature

9. (a) yes...

20English 38225; =20 pounds=£ 20
15 $ 15 =$15
10.5 euros = 10.5 euro=10.5

10. In the process of using Excel statistical data, sometimes you need to add a currency symbol before the number. For example, in the following excel form for recording daily income, you need to add an amount
& quot before entering the number in the income column; ￥"
currency symbol, but the input number is only the number, no currency symbol, how to solve it
if you need to add a currency symbol before a number, you can use the excel "set cell format" dialog box to modify it.
the following author takes excel
2007 as an example to illustrate the operation steps of adding a currency symbol before a number:
(1) first, right-click the cell under the revenue column and select "set cell format"
(2) in the "set cell format" dialog box, select the "number" tab, find the "classification" option, select the "currency
" item, and find
& quot on the right; ￥"
currency symbol, and the number of decimal places can be set as required (I set it to 0)
How about adding ￥ & quot; before the input number automatically; The currency symbol has changed.