try - copy - paste - into a new workbook already formatted to number then from there copy - paste special - values - into your existing workbook, may help, however it probably has more to do with the web page formatting, something there that excel does not like