Excel digital automatic 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. Select all the tables, and then Ctrl + Shift + ~ should be OK. The last symbol is the wave sign. Try it

4. Set cell format to text. Whatever you enter is what you want.

5. Please set the properties of each cell, right-click the cell, select "set cell format", and select the required classification on "number". If you're not wrong, your current cell classification is "currency" in the third attribute.

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

7.

After selecting this column of cells, set the cell format

8. Even if it is automatic, the exchange rate is changing every day, will your excel automatically change
the most common way is to input the exchange rate and make a fixed form.
If A1 is the value you input 100, then your exchange rate is marked with A2 0.638, and the value you need is marked with A3. You only need to use a1xa2, and your fixed form can be made, but in this way, all kinds of currencies have to use different forms
sorry, that's all I can do! Hope to help you.

9.

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: