| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I give numerical values to each text item in a list | Excel Discussion (Misc queries) | |||
| text and numerical values in two columns | Excel Discussion (Misc queries) | |||
| text has numerical values | Excel Worksheet Functions | |||
| Assign numerical values to text codes | Excel Worksheet Functions | |||
| converting from text to numerical number | Excel Discussion (Misc queries) | |||
Linear Mode
