Converting text to numerical values
 

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.

Converting text to numerical values
 

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.