On Dec 21, 6:43*pm, Javed wrote:
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.

Thanks for the reply...
but I have data in mixed format in the column....so I cannot do as per
your suggestion.