Numbers from the web pasted in excel as text

Help Activities
,
1

Hi everyone,

I’ve been having trouble trying to find out why certain numbers are pasted as text and the others as numbers.

We get the text from a number of different website and use the add data row to include into the datatable variable with the following.

{"str_var0", str_var1, str_var2.Replace("EUR, incl.",""), str_var3.Replace(".","").Trim}

After doing the same thing with a number of different sites the results are pasted either as numbers or text. We need everything to be numbers to able to do further operations on them.

image

Would be grateful for any help.

Thank you in advance

2

Hello.
have you tried convert to number ? cint(var) or CDbl(var) ?