How to copy numbers without currency

1. Format & gt; Cell format & gt; Value & gt; Custom number format

2. You have two problems with this
one is: select column, set cell format, set to normal
Second, select the column, press Ctrl + H, enter RMB symbol in the search column, and click replace all

3. Select all, - & gt; Paste special - & gt; Value
then, use automatic filter to find one column that has not been summarized and filter blank

4.

1. Use Excel to open our data table, and then select a cell to input the formula

in the cell

5. Copy the whole table right click Paste select value OK

6.

Right click to select Paste numbers only

1. Create a table calculated by formula

7. If this is the only one, double-click to select and . If there are many and fixed positions, use the mid function to take out several bits of the data, such as B1 = mid (a1,3,11)

I'm more interested in how this table is made. The top and bottom do not correspond, and there is no formula

9. Copy the content of QQ column to a new document or table (remove the other content in the original table), and send the file.