How do the numbers in the table become 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.

After selecting this column of cells, set the cell format

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. Suppose the text is in A1,
enter the formula:
= -- A1
then the cell where the formula is located, paste the value to the place you want, and set the pasted cell to currency format.

6.

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

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

8.

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

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

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

10. I guess it's text format, so I'll take out ￥. In the new column = -- right (A1, len (A1) - 1), drop down, remove ￥ and set it to currency format