Excel number format set to 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.

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:

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

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

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.

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:

8. Select the area, right-click in the selected area, and "set cell format" -- "number" -- "currency", as shown in the figure:

"OK" -- enter data, as shown in the figure: