How to type the currency symbol before excel number

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

2. Insert - select the symbol you want in the symbol. Double click it. If there is no insert - symbol, select Insert - special symbol. There must be some.

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. Click the cell with symbol, right-click, select custom in the number option, and click "delete" at the bottom of the box

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

6.

If A1: A13 is a number with RMB symbol (in fact, it is already text), then enter the formula = superproct (- - substitute (A1: A23, & quot; ￥",)) That is to sum. See the figure below:

7. Take excel as an example, first enter the number "58" in the cell, and then click the "currency" command in the "start" tab "number" drop-down list. At this time, it will be automatically displayed in the form of currency. In this way, you can set the currency for the whole row or column, Of course, if you only need to input RMB symbol in word or excel, you only need to input 4 / $in full angle Chinese, and this key will automatically display ￥ symbol. You can also input currency symbol by inserting symbol
sometimes RMB symbol may not be used in Excel, but other currency symbols may be used. At this time, we can change the default currency format. The specific steps are as follows:
1. Click the start menu on the desktop, and then click the "Settings" - "control panel" command in the list
2. Open the "regional and Language Options" dialog box, Click the Customize button on the Regional Options tab
3. Open the "custom Regional Options" dialog box, click the "currency" tab, and select the currency you want to change in the currency symbol list. The decimal number can also be set according to your needs
4. Return to excel and set the cell to currency format, then you will set the default currency format.

8. That symbol is just a display format, does not affect the calculation of the!!!

9. The reasons are as follows: 1. The reason for the emergence of money: the development of social proctive forces and social division of labor makes exchange more and more frequent and complicated, which requires an intermediary of exchange. It is in this process that money graally emerges
2. The process of money generation: accidental barter, expanded barter, the emergence of general equivalent and the generation of money
money is a fixed commodity separated from commodity and serves as a general equivalent.
the essence of money is a general equivalent