How to set the number format to currency in Excel
To convert a number to a currency number is to set the value cell format to currency format. The following steps are as follows:
-
select the cell to be set, right-click to select the cell format
-
to open the cell Format dialog box, click the number tab (the general default number tab is activated)
-
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:
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ￥")
press Ctrl + Shift + enter to end the formula, and then drop it down
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.
First, we open excel on our computer, and then we input a number in it
The steps of setting currency style in Excel are as follows:
prepare materials: Excel software, computer
1. Open the Excel software and open the excel table to be edited, as shown in the figure:
Set cell format to solve
excel version reference: 2010
1, select salary column (demo in column a)
2, click start number (Click small triangle to select currency)
3, view effect