If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|