Add currency after excel number

1. Set cell format to text. Whatever you enter is what you want.

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

3. Tengjia enamel steel water tank is to use HSC series enamel as base glaze and surface glaze δ 2- δ 5. A new type of water tank is assembled by firing plates on enamel.
Tengjia stainless steel water tank is commonly used as stainless steel fire water tank, and the square combined water tank is made of SUS304 and stainless steel plate, which is formed by stamping.

4.

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

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

6. There are two methods< br />1 Enter the dollar symbol directly when inputting data< br />2 Select the cell for which data (number) has been entered, select [format] - [cell] in the menu bar, set its classification as "currency" in the [number] tab, and set its decimal places and currency symbol as "$" on the right side. OK to set all selected cells to dollars.

7. Football world weekend shopping mall is in the activity center. There is an activity center in the lower left corner of the main interface. There is a weekend shopping mall at the bottom of the activity center.

8. You can find this one in Japanese from the input method

9. Custom format 0 & quot; US dollar;, This is an integer with two decimal places, 0.00 & quot; Dollars & quot
currency styles can be modified. Format - style, select currency in the style name, and click Modify to change it to your own format.

10. Directly select the cell, right-click, and select set cell format - number - currency - currency symbol. Choose any symbol you want. Convenient and fast!