The number becomes a currency symbol

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.

After selecting this column of cells, set the cell format

3.

Take excel 2016 as an example, there are the following steps:

1. Open an excel worksheet, as shown in the figure below:

4. Tengjia enamel steel water tank is to use HSC series enamel as base glaze and surface glaze δ 2- δ 5. A new type of water tank is assembled by firing plates on enamel.
Tengjia stainless steel water tank is commonly used as stainless steel fire water tank, and the square combined water tank is made of SUS304 and stainless steel plate, which is formed by stamping.

5. The common material of enamel water tank is hot-rolled pickling steel with yield strength of 245

6. This is the problem of setting up. Proceed as follows; After opening excel, right click Select; Set cell format --
select; Number selection; General - click OK to restore.

7. Click the cell with symbol, right-click, select custom in the number option, and click "delete" at the bottom of the box

8. That's your code

9. Black data cell right click Set cell format number numerical value OK

10.

This is because the classification of numbers has been changed and all numbers are default to "euro currency", as shown in the following figure:

< UL >

note: you can also use the shortcut key combination of "general" type, as follows:

< / UL >

1. Press "Ctrl + a" on the keyboard to select all tables

2. Press "Ctrl + Shift + ~" on the keyboard

directly returned to normal