View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Changing text to value

Here's another very quick way I picked up a week or so ago:

Highlight the column that you want to convert
Click Data | Text-to-Columns then click Finish

Repeat for any other columns.

Hope this helps.

Pete