This usually works.

Format all to General.

Copy an empty cell.

Select the range to change and EditPaste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Mon, 15 Feb 2010 19:13:01 -0800, J wrote:

I have down loaded a spread sheet using excel. Excel is reading the values
as nonnumerical values. How can I convert the numbers into numerical values
the computer can read so I can us the analysis features.