View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BRob BRob is offline
external usenet poster
 
Posts: 24
Default Converting text to numbers

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