Numbers from the web pasted in excel as text

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.


Would be grateful for any help.

Thank you in advance

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