How to put currency symbols before numbers in tables
Select this column or a cell, as shown in the figure below, select A1: A2, click "column" under the "data" menu,
people's Republic of china, "flor 165;" Gennosuke-sama, let's go. We got the best news out of the world:; 100 "or" RMB amount 165; 100”
“¥” Judging from the former people's level of an order, a national people's way of drawing, an immoral people's way "yuan". < / nowiki > P >
inexplicably floocture count Abe crush for nuclear conversion a number or a flood-iron transport floom um um, and a flood-iron flood-iron flo count of a flood-iron ion ion ion ion ion ion ion ion ion ion ion ion ion ion ion ion ion ion card in a subdirectional medium size, a flooction-dono, and a flooction-dono previous position Junsu x "flo 165 km" Marks, an unbreakable gold additive number, and a modified people's dollar balance. < / nowiki > Yu Body of the people who appear as' yuan ', and because of that, let's Add' 165; ' A negative, gold shorthand, empress coworker unappreciated “ yuan ”. < / nowiki > P >
{rrr}
Japanese conjunctions: 165; & quot;( I don't know people's Republic of China original (presented) as an elected people's republic P > the physician (yen) and the lawyer (yan). There is nothing to do from time. The universal order of motion; and the illiterate way of action; True; The 'twoj' transcripts, and meta'imame 'the Tai yat-sen; the ink-seeing level; the ink-seeing of the Jamo y; the ink-seine ine ine ine ine ine ine ine ine ine; the ink-seeing minor number. < / how the area is wide and in such a position as in world, the general printing law, suddenly, you have a wide position position position position position position position position, and a general finding finding, and a world wide exalted exalted; and United Nation nation nation nation nation nation, have an established established addition character character be careful, or the former subscriber JPY handwriting was recorded before or my my my day my my location, be careful, and addition addition ward, addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition addition, and being being being being recorded recorded recorded before the world, and the hell hell hell hell hell hell hell hell hell hell hell hell hell one. But he should have known the people of japan, of course, from very fine japan p>
the symbol of RMB is. The writing order is:
1. First write the capital letter "Y", and then add two horizontal lines on the vertical line, that is "" and the pronunciation is: Yu á N (sound: yuan)
2. When you use Arabic numerals to fill in the amount one by one in the form, you can add a "" sign before the first amount, which can not only prevent you from filling in numbers 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 information:
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 small amount figures, there should be no space between the RMB symbol "￥" and the figures, so as to prevent the amount figures 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't use the "￥" symbol when registering account books and preparing reports. Because using "￥" symbol on account book or report will increase the possibility of error
reference: Internet - RMB symbol
The operation method of adding currency symbol to cells in excel is as follows:
-
first, select cells (such as m54), right-click the cell range, and select "set cell format"
-
next, click "number" -- "currency", select the corresponding currency symbol, such as "￥", and then click "OK"
-
finally, click "OK"< br />
B1
C1
D1
E1 represents cell 1. First, put these five column cell formats, 1. Point to the five column ABCDE, 2.
right click 3, number 4, decimal number 5, currency symbol. The numbers below these five columns are all decimal with ￥. 2、 Just add and subtract functions in the cells below the balance. 3、 Click on the cell grid under the second debit. 2. Click on the function symbol. 3. Click on the grid where you want the number to come in. 4. Click on the function OK. 4、 The agent operates in the same way as the borrower. 5、 Just pull down the grid.
-- OK, as shown in the figure:
"￥" does not need to input
to select the format