Data is downloaded from web. You should sum up the values you downloaded. However, this does not happen without some modification.

The numeric values don’t get summed.

The cell category is number.

Replacing the space with SUBSTITUTE does not work.

If you replace character number 160, then the thousand separator will disappear. SUM function does not work.

Again the cell category is number, but calculation does not work.

When you frame the previous sentence with VALUE function, the cell gets numeric category and calculation works fine.

=VALUE(SUBSTITUTE(B2;CHAR(160);””))

If you take value from cell with space, the VALUE function does not work.