Jo Dee

One method......

Format all as General.

Copy an empty cell(also formatted as General).

Select range of numbers. EditPaste SpecialAddOKEsc.

One other method.........

Select range of numbers and DataText to ColumnsFinish


Gord Dibben Excel MVP

On Sun, 27 Feb 2005 11:53:06 -0800, Jo Dee <Jo
wrote:

I imported files from Wells Fargo and I want to convert them from text to
numbers...so far nothing is working! thanks