Converting text to numerical values

  • Thread starter Thread starter J
  • Start date Start date
J

J

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.
 
This usually works.

Format all to General.

Copy an empty cell.

Select the range to change and Edit>Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP
 
Back
Top