I have built a database where most of the data is text data. This option was chosen to increase ease with data entry. Now I want to analyze this data under a data analysis software (SPSS). Is there a simple way for me to convert my text data into numerical data. For example, one of my variables, ethnicity, has options: African American, Asian, Hispanic, and European. I would like to convert African American to 1, Asian to 2, Hispanic to 3, and European to 4. What are the best ways to convert text variables to numerical variables.