Current location - Loan Platform Complete Network - Big data management - The number copied from the Internet is not the number in EXCEL. What should I do?
The number copied from the Internet is not the number in EXCEL. What should I do?
Case 1, numerical mode but cannot participate in calculation.

This can be opened with the 2007 edition. Click this number with the left key, and a yellow background will appear on the left! , click the pop-up convert to digital option, and then execute. This transformation can be multi-selected, that is, one column is selected together and transformed together.

In the second case, there are special characters in the number, such as commas and RMB symbols, which can be removed by using the substitution function. Paste what you want to delete in the search content of the search replacement interface, replace nothing in the box, and then execute.