How to add currency symbol before number in Excel

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

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

3.

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

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

5. 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 a currency symbol before a number, you can use the excel "set cell format" dialog box to modify it.
the following author takes excel
2007 as an example to illustrate the operation steps of adding a currency symbol before a number:
(1) first, right-click the cell under the revenue column and select "set cell format"
(2) in the "set cell format" dialog box, select the "number" tab, find the "classification" option, select the "currency
" item, and find
& quot on the right; ￥"
currency symbol, and the number of decimal places can be set as required (I set it to 0)
How about adding ￥ & quot; before the input number automatically; The currency symbol has changed.

6.

The method of adding currency symbol in front of the number in Excel table is described as follows:

1. For the quotation as shown in the figure, add RMB symbol in front of the unit price quickly

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.

Taking Microsoft Office Excel 2007 as an example, this paper introces how to automatically add dollar symbols in Excel rows or columns:

1. Open the excel document you need to use

2. Select the row or column to be set with the mouse

3. Right click on the selected row or column

4. Click "set cell format" in the pop-up dialog box

5. Click the "number" tab in the "set cell format" dialog box

6. Click "currency" again

7. Click the drop-down triangle behind the blank box after "currency symbol (country / region)"

8. Click the dollar symbol to be selected

9. Click "OK"

9. 1. The area of the selected value
2. Right click the selected area and select set cell format from the shortcut menu
3. In the "numerical value" tab of the pop-up dialog box, select "currency", and then set the required number of decimal places and currency symbol on the right to confirm.

10. This is the symbol of reference format in Excel formula
if you press Shift + 4, this is the symbol
if you are editing formula, you can press F4 function key to switch the symbol when editing formula in the edit bar to change the reference mode

after reading your supplement, it shows that the answer I give you is correct