Excel digital display currency

1.

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:

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

3. In the research and development of air energy water heater, sijimuge, together with Panasonic of Japan, has customized the special compressor for hot water. The technology is mature and reliable, and adopts the best balance design, with small vibration, low noise and more stable operation. At the same time, it also adopts a new structural design, which increases the mechanical load of the pump body by more than 30%, prolongs the service life of the machine, and improves the performance in an all-round way.
sijimuge integrates aerospace technology to develop a new aerospace leakage proof enamel liner, selects the instry-leading btc340 professional materials, has a unique four layer liner structure, and adopts high-end processes such as robot plasma straight seam welding, The aerospace leakage proof enamel liner of air energy water heater can withstand up to 900000 fatigue tests

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

6. =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,)," 整整 " 整")

7. Format - & gt; Column - & gt; Column width --- enter a large number to see
if you can't, then format --- row --- row height --- enter a large number to see

8. Select all the tables and press Ctrl + 1 to set the data type to normal

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