AnsweredAssumed Answered

Fastest way to convert text choices on collection form to numerical values on table

Question asked by EmersonChen on May 3, 2012
Latest reply on May 3, 2012 by philmodjunk

Title

Fastest way to convert text choices on collection form to numerical values on table

Post

Hi I'm trying to enter 400 data observation via collection form into a database.

Some of my variables are multiple choices (such as gender, marriage status, and race) right now text variables.

How do I enter them so in data collection form they are still seen as "Male" "Female" and "single" "married" but become numerical values in the table.

When I download later into excel sheet, I want most of my values to be numerical.

Outcomes