Excel number type currency type

1.

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

2. Select all the tables, and then Ctrl + Shift + ~ should be OK. The last symbol is the wave sign. Try it

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

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:

6. Hello
you can add and subtract directly, such as
= a1-b1
if it is helpful to you, please adopt it.

7.

There are four types of data in Excel, which are numeral type, logical type, date type and text type

by default, excel cells are regular. This does not mean that there are conventional data, but that excel will "intelligently" determine the data type when entering data in conventional cells. Intellectualization is a trend of Excel development, such as the addition of Ctrl + e function key after 2013

extended data:

excel text can be text, numbers and symbols. Note that spaces, = signs are also text. Many times, we need to set numbers to text type, such as ID number, number 0, and so on. First enter single quotation marks and then enter numbers, you can quickly save numbers as text

The fraction, percentage, currency, etc. in Excel cell format are all numerical in nature, only changing the display format

8. This is relatively simple. Select the cell to be set in Excel, and then right-click the table property and select currency type

9. Select the currency format area to be adjusted, and press Ctrl + Shift + ～. Hope to adopt it. Thank you!

10. There is no difference. Enter it directly, and then set the cell format, or set it in advance