Table number with currency symbol

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

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

1. Select the cell to add

2, right-click / set cell format

3, number / classification / Accounting specific

4, confirm

1. First, open the table to be set on the computer, click the letter at the top of the cell, and select the whole column

If the currency symbol is a Chinese character, the cell becomes text format, so it cannot be summed. So we need to replace Chinese characters with English characters. The symbols of d5 and D7 in the figure below are different. D7 is a Chinese character and cannot be calculated

1. First, we open excel on our computer, and then we input a number in it