I have tried copy and paste the columns as format 'general' to remove any text as this did occur to me as well but it still does not stop the #VALUE error. Is it something to do with the way I am copy paste special the data as 'values and number formats only' from the original spreadsheet or something to do with the original spreadsheet containing the formulas?