On Thu, 29 Sep 2005 02:56:02 -0700, "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

For a formula:

=--(A1="yes")

will give a result of 1 for Yes and 2 for No.


--ron