Excel figures in currency

1.

The number in excel is changed into currency "#" format mostly e to the use of other formats, which can be changed back to numerical value or conventional. The specific steps are as follows:

required materials: Excel

First, open the excel file and select the number cell in currency format

2.

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

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

4.

After selecting this column of cells, set the cell format

5.

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:

6. If you mean that a cell in regular format will change to currency format after entering a number, please try the operation:
1. If the number is pasted, please select the value "123" in
"paste special"
2. If the number is manually entered, please right-click the cell containing the number, Set the cell format, select "general"
or select the cell containing numbers, and then click Ctrl +! Shortcut key, you can quickly open the cell Format dialog box, select "general" or other data types you need.

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

8. Keep an excel instance, delete some strange symbols in the custom format... What is it? I forgot...

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

10. I guess it's text format, so I'll take out ￥. In the new column = -- right (A1, len (A1) - 1), drop down, remove ￥ and set it to currency format