Problem with decimal points

Originally Posted by martindwilson

which ones? h2 to h18 are text but h19 onwards are real numbers with 1000 seperators

I have checked the suppliers original price list and the format is numbers but when I paste into new sheet the format changes to a combination of general and numbers.