How to add currency symbol after the number in the table

1.

How to input currency symbol in Excel cell:

1. input currency symbol first and then number directly in cell

2. select the cell range to input currency, right-click, click "set cell format" in the shortcut menu, and select the display mode of "number" -- "currency" -- "currency symbol" -- "decimal digits" -- "negative number"

   In the first method, you need to input the currency symbol every time, but you can have a flexible number form, which can be displayed as an integer or two decimal places. In the second method, you only need to input the number directly, and you don't need to input the currency symbol, but you need to determine the decimal places in advance, All are displayed in this decimal place

2. Select data area, right-click, set cell format, number, currency, as shown in the figure:
-- OK, as shown in the figure:

3. 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.

4. Select the cell where you want to input currency symbol, and right-click - set cell - number - currency (select the currency symbol you want)
after this setting, you do not need to input currency symbol any more, you can input number directly to display both currency and number.

5. 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

6. Select the cell and right-click to select & quot; Format Cells & quot
Select & quot; Currency;, On the right, select your & quot; Currency symbol & quot;

8.

As shown in the figure below:

1, insert -- & gt; Symbol -- & gt; More

9. In fact, this problem is very simple, but you don't need to use the custom "@" to achieve it, because it has a lot of inconvenience, and it may not be able to achieve the requirements of the owner in one step. The most correct way is to use the "general format",
the method is as follows:

1 - first select all the cells you want to add kg

2 - right click to select "set cell format" -- "number", select "custom" under "classification"

3 - enter g / general format & quot in the type box on the right; kg" Or enter # & quot; kg"

4 - click OK

all results can be automatically followed by "kg" unit effect!