Excel numbers represent currency

1.

The reason for this phenomenon is that there is a problem in the setting. The specific solutions are as follows:

1. First, create a new excel document

2.

To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:

1. select the cell to be set, right-click to select the cell format

2. to open the cell Format dialog box, click the number tab (the general default number tab is activated)

3. to select the currency symbol and decimal point according to your own needs, Then determine the specific recording operation of

< / OL >

as shown in the following figure:

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 on the top of Excel table, format - number - currency - alignment - right. The actual table is right by default, and it is OK not to click alignment.

6. Open the control panel. There is a region and language on it. Double click to open the dialog box. Click the custom button on the regional language tab and the number tab to see if your decimal point is set to comma

7.

In Excel, data can be displayed as currency format by setting cell format:

1. right click cell to set cell format< br />

   

8. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(G5),"[ dbnum2]G/[UNK][UNK]州元quot;""" IF(MOD(G5,1),"& ",& " 整 ";;" ";)" TEXT(--RIGHT(INT(G5*10)),"[ dbnum2][> 0]#[UNK];[= 0]")& TEXT(--RIGHT(INT(G5*100)),"[ dbnum2][> 0]#[UNK];[= 0]整 quot;),& " 元0",& " 元零 quot;), 0,)," 整整 " 整")

9. Hello
you can add and subtract directly, such as
= a1-b1
if it is helpful to you, please adopt it.

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