Excel number format is currency format

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.

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:

5. Excel sets the data to currency format: select the cell range, press Ctrl + 1, select currency, set currency symbol, etc

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

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

8. Suppose the text is in A1,
enter the formula:
= -- A1
then the cell where the formula is located, paste the value to the place you want, and set the pasted cell to currency format.

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