Where is the currency of Excel digital format
Publish: 2021-05-22 23:36:46
1. 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!
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:
-
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:
3.
1. The computer opens the excel table and selects the data to be marked with currency
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. Select the area,
right-click in the selected area to "set cell format" -- "number" -- "currency", as shown in the figure:
OK "-- enter data, as shown in the figure:
right-click in the selected area to "set cell format" -- "number" -- "currency", as shown in the figure:
OK "-- enter data, as shown in the figure:
6. I haven't played this game before. I know Xuanyuan legend mobile game is not bad. To be honest, players all have a version of mobile game in their mind. Some want to keep the integrity of occupation and skills, some hope to improve the previous end game playing methods, and some worry that mobile game will become other styles. But when I play this legendary hand tour of Xuanyuan, once I enter the game, the scene and experience of Xuanyuan City, seven kill array, God killing, treasure refining and so on are full of familiarity. This is my Xuanyuan legend hand tour
7. 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.
8.
First, we open excel on our computer, and then we input a number in it
9.
In Excel, data can be displayed as currency format by setting cell format:
-
right click cell to set cell format< br />
Hot content