The column contains mixed data types and the data was pasted as text. PowerPivot can automatically add a calculated column ...

The column contains mixed data types and the data was pasted as text. PowerPivot can automatically add a calculated column with a numeric data type and replace any non-numeric values with NULL. This will enable you to use the data in calculations.