| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
One more...
Select the range to fix: edit|Replace what: Yes with: 1 replace all do the similar thing for No. Tonny wrote: I want to convert some 'Yes/No' answers into numeric (i.e. Yes=1; No=0). These will then be inputted into SPSS. How do you convert text to numeric in Excel? Thanks in advance -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
| convert a number in Excel from numeric to text, i.e. "1" to "one" | Excel Worksheet Functions | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
