Set number as currency in Excel
Publish: 2021-04-24 22:19:36
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. After opening the file form, select the cell that needs to set currency, there is a format option in the upper right corner of the form, which can be set as currency. If you don't understand, please leave a message and ask. Thank you!
3.
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:
4. If the data is in column a, you can enter the formula in B1:
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ￥")
press Ctrl + Shift + enter to end the formula, and then drop it down
= replace (A1, match (, 0 / mid (A1, row ($1): $99), 1),,, & quot; ￥")
press Ctrl + Shift + enter to end the formula, and then drop it down
5.
1. First, you need to open the Excel software in the computer, open the data, select the cell, and right-click the cell
6. 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.
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.
7. The common material of enamel water tank is hot-rolled pickling steel with yield strength of 245
8. Right click the cell and select Format cell. Select the number tab in the pop-up window. Select currency in the window. After selection, you can set decimal places and currency symbols in the window on the right. After setting, click OK to finish setting.
9. Menu - Format - cell - number - currency
10. 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
if you can't, then format --- row --- row height --- enter a large number to see
Hot content