Thanks for the feedback, Steve...I'm glad I could help.

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

XL2002, WinXP-Pro


"Steve Williams" wrote:

Works like a dream come true. Thanks for the help.

Steve Williams

"Ron Coderre" wrote in message
...
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