Many times when copying data from the Internet to Excel, the numbers present commas as thousands separators. As much as we change the format of the cell to number, it is still text because Excel cannot understand the thousands separator after the figure has 6 digits, that is, more than a million.
I will show the case of this Internet statistics table, which I I spoke a couple of days ago:
See how the copy / paste works, as long as it doesn't send the merged cells. But those numbers go as texts.
The exit for them takes three simple steps:
1. Format cells as text.
This is done by selecting the text, right-clicking and choosing Format Cells. Then there we make the change.
2. Find and replace commas.
This is activated with the Ctrl + b key in the case of Excel in Spanish. The option to find the comma (,) is chosen and the replace box is blank. Then the button Update all.
The result is that all the commas will be erased. Be careful, because the selection should only include the numbers that we want to change so that it does not damage parts of the file where there are commas that are valid.
3. Format cells as numbers.
Then step 1 is repeated, but indicating that the format is a number.
How to remove multi-cell hyperlinks
Sure for this there is another way but I let it go because it is on the tip of the tongue in the same exercise. Deleting one by one is not a problem because it is done with the right mouse button, but to do it to several cells it cannot be done even with Copied and pasted specialBecause if we ask Pick values The hyperlink will always be left because it is inserted in the cell as xml and not in the text.
What you can do is copy everything that interests us, to a blank column with the special paste option, paste links.
Those cells will have the content but not the hyperlink and these can be copied and pasted values to the original cells.