View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Williams
 
Posts: n/a
Default Coverting text to numeric

In Excel 2000:
I have a column of numbers as formatted as text. How can I convert them to
numeric. Reformatting the cells as numeric and using F2 is not an option as
I have several thousand rows to convert in this column.

Steve Williams