How to add currency symbols to numbers

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

2. (1) Select the range of cells to format 2) Right click the selection and choose Format Cells from the shortcut menu 3) In the pop-up dialog box, in the number tab list, select custom 4) In the type text box on the right, enter ￥ 0.00 (5) to confirm.

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

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.

1. Select the cell to add

2, right-click / set cell format

3, number / classification / Accounting specific

4, confirm

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

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

8. In the process of using Excel statistical data, sometimes you need to add a currency symbol before the number. For example, in the following excel form for recording daily income, you need to add an amount & quot; before entering the number in the income column; ￥" Currency symbol, but the input number is only the number, no currency symbol, how to solve it? If you need to add currency symbol before a number, you can use Excel "set cell format" dialog box to modify it. The author takes Excel 2007 as an example to explain the operation steps of adding currency symbol before a number: (1) first, right-click the cell under the income column and select "set cell format" 2) In the format cell dialog box, select the number tab, find the category option, select the currency item, and find & quot; on the right; ￥" Currency symbol, decimal places set according to the needs (the author set to 0). How about adding ￥ & quot; to the input number automatically; The currency symbol has changed.

9. Explain that the value of your formula is the text value. Write up the formula and have a look. Maybe you can change it

10. Right click the mouse, select "format cell", select "numerical value" in the table below "number", and remove the check in "select thousandth symbol box"; Select "special for accounting" and select "currency unit ￥" in the lower list on the right