Converting text to numbers

B

BRob

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
 
G

Gary''s Student

If the data is in columns, you can try Text to Columns, mapping the column
back onto itself.
 
Top