How to get drop-down list to display text and #s but insert only #

J

JHartle

I am creating a survey and each cell has a drop-down list that displays the
Likert scale from 1-5. I would like the drop down list to display the Likert
description in the drop-down, for example: 1-Strongly Disagree, 2-Disagree,
3-Neutral, and so on up to 5. But when the user selects one of the options, I
would like only the number to be inserted into the field because we are
averaging the scores.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I display text and #s in a drop-down list, but insert only 4
creating a graph from a drop down menu 2
Drop down list 1
Drop Down List 3
How to Update drop-down list? 5
Drop down list and macros? 1
Excel Excel: How do I put a formula in a drop down list 11
Drop Down Lists 2

Top