Excel does not add currency symbols to numbers

1. It may be that you have defined the format. You can select the cell, right-click to set cell format, number and have a look

2.

Required raw materials: 2016 excel

method of adding and deleting currency symbol in Excel:

1. select the content of currency symbol to be added in the excel document

2. right click to select cell format, and select currency in the number (no need to select none)
   

< / OL >

3. For example, if you want to enter "1000" in a cell, then you can select the cell with your mouse, right-click "set cell format" and select "currency" under the category of "number", and then you will see "decimal digits", "currency symbol" and other options on the right, You can choose the symbol you need!

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

5.

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 />

6.

1. Select the cell to add

2, right-click / set cell format

3, number / classification / Accounting specific

4, confirm

7. This is because the thousand separator you entered is & quot& quot; Instead of a comma & quot& quot;, In this way, the number will become a text string and cannot be converted in currency format.
it is recommended to write the number directly instead of adding a thousand separator, and the currency format will be automatically added

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

9.

Through setting cell format to access currency symbols, you can directly participate in the calculation of

Demo:

1, select the cell area to be formatted

2, Ctrl + 1, number currency, select the required currency symbol

3, determine