View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Coverting text to numeric

Hi, Steve

There are a few different approaches.
See if this works for you...

Select the column of "numbers".
If the number format is Text, change it to General or any other appropriate
format.

<Data<Text-to-columns
Select: Fixed Width
Click the [Finish] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Steve Williams" wrote:

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