Table input number 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. Set cell format to text. Whatever you enter is what you want.

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.

Tools: word software

1. First, use Excel to open the prepared worksheet, open the cell of setting currency format, and select the "number" option in the start tab< br />

8. First set the cells to the currency format you want, and then enter the data. The method is: first select some cells or a column to be changed into currency format, then open the format menu, and set the cell format in currency on the number tab. If you don't have what you want, you can first select a similar one, and then click Custom to modify it.

9. If the original ￥ is entered manually, excel will recognize it as text, so it cannot be directly converted to currency format
you can delete ￥ in batches by using the search and replace function, and then set it to currency format.