if you have a column numbers stored as text.No need to select all
individually.

Select the first cell of column which stored as text then click on
error indicator and get all converted.