I've imported a csv file where everything as come through as text.

I want to convert the entries in some columns from text to numbers.

I can do it individually by clicking on the warning icon (!) at the side of
each cell and choosing the relevant option.

But can SKS tell me how to do it for a range.

TIA

Rob

If the data is in columns, you can try Text to Columns, mapping the column
back onto itself.
--
Gary''s Student - gsnu2007g


"BRob" wrote:

> I've imported a csv file where everything as come through as text.
>
> I want to convert the entries in some columns from text to numbers.
>
> I can do it individually by clicking on the warning icon (!) at the side of
> each cell and choosing the relevant option.
>
> But can SKS tell me how to do it for a range.
>
> TIA
>
> Rob
>
>
>

try selecting all cells, press ctrl+C twice and click the paste icon.