Excel open number is 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. 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.

5.

After selecting this column of cells, set the cell format

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

7. In the research and development of air energy water heater, sijimuge, together with Panasonic of Japan, has customized the special compressor for hot water. The technology is mature and reliable, and adopts the best balance design, with small vibration, low noise and more stable operation. At the same time, it also adopts a new structural design, which increases the mechanical load of the pump body by more than 30%, prolongs the service life of the machine, and improves the performance in an all-round way.
sijimuge integrates aerospace technology to develop a new aerospace leakage proof enamel liner, selects the instry-leading btc340 professional materials, has a unique four layer liner structure, and adopts high-end processes such as robot plasma straight seam welding, The aerospace leakage proof enamel liner of air energy water heater can withstand up to 900000 fatigue tests

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

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

10. Open the control panel. There is a region and language on it. Double click to open the dialog box. Click the custom button on the regional language tab and the number tab to see if your decimal point is set to comma