Question: I am struggling with a data validation function I want to include. The thing is that I have a list of 10 rows:
1 -No effect
2 -Customer not annoyed
3 -Customer slight annoyed
4 -Customer experiences minor nuisance
5 -Customer experiences some dissatisfaction
6 -Customer experiences discomfort
7 -Customer dissatisfied
8 -Customer very dissatisfied
9 -Potential hazardous effect
10 -Hazardous effect
I like to see the complete text in a data validation pulldown list, but when I make my choice I only want to see a value 1 to 10 in that particular cell. Reason: I want to see the complete text in the pulldown list to understand what the numbers stand for and make my choice but I only need a number 1 to 10 for further calculation and not the complete text.
How can I achieve this?
Bookmarks