Forum Discussion
Copied pasted number values from WEB are treated like strings
Hi,
The numbers you import from the web are NOT numeric numbers in Excel, Excel treats them as texts.
You see them aligned to the left, and this is the default alignment of any text in Excel.
When trying to sum them, SUM function returns 0 since there are no numbers to add!
The reason that makes Excel treats them as texts is the difference in the default decimal separator on your computer, and the decimal separator used in the imported numbers.
Anyway, leave the default decimal separator as it is "," .
The solution is so simple:
Select all the numbers, and press Ctrl+H to open the Find and Replace tool.
Type "." in Find what box, and type "," in the Replace with box, and then hit Replace All.
- Gintaras PacevičiusMar 06, 2018Copper Contributor
This is a good answer, of course I can find and replace separator. Isn't there any auto change if you have 'a' change to 'b'? Because my client has a co-worker that just copy paste the same data ant it's comma not a dot as separator. I wonder why?