How to add currency symbol before excel number

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

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. Click the cell with symbol, right-click, select custom in the number option, and click "delete" at the bottom of the box

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

7. Take excel as an example, first enter the number "58" in the cell, and then click the "currency" command in the "start" tab "number" drop-down list. At this time, it will be automatically displayed in the form of currency. In this way, you can set the currency for the whole row or column, Of course, if you only need to input RMB symbol in word or excel, you only need to input 4 / $in full angle Chinese, and this key will automatically display ￥ symbol. You can also input currency symbol by inserting symbol
sometimes RMB symbol may not be used in Excel, but other currency symbols may be used. At this time, we can change the default currency format. The specific steps are as follows:
1. Click the start menu on the desktop, and then click the "Settings" - "control panel" command in the list
2. Open the "regional and Language Options" dialog box, Click the Customize button on the Regional Options tab
3. Open the "custom Regional Options" dialog box, click the "currency" tab, and select the currency you want to change in the currency symbol list. The decimal number can also be set according to your needs
4. Return to excel and set the cell to currency format, then you will set the default currency format.

8.

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

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

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