Many times when copying data from the Internet to Excel, the numbers have commas as separators for thousands. As much as we change the format of the cell to number, it is still text because Excel can not understand the thousands separator after the number has 6 digits, that is, more than one 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 does not send the merged cells. But those numbers go like texts.
The exit for them takes three simple steps:
1 Give cells the text format.
This is done by selecting the text, right clicking and choosing Format of cells. Then there we make the change.
2 Search and replace commas.
This is activated with the Ctrl + b key in case of Excel in Spanish. Choose the option to find the comma (,) and blank the replace box. 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 Give cells the number format.
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 loose it because it is on the tip of the tongue in the same exercise. Delete one by one is not a problem because it is done right mouse button, but to do it to several cells can not be done or 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.