1 Reply Latest reply on May 3, 2012 9:10 AM by philmodjunk

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

    EmersonChen

      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.