I read this topic: Excel cells - show text different to the actual value?, and now I'm trying to use it as a Data Validation list in Excel. But when I choose for the list those cells, when I choose one of them it shows me the value data and not the display text (I'm using Microsoft 2007).
Here is an example:
Instead of showing "Thursday" it shows me in the cell the value of Thursday: "5"
How can I get the chosen value of the list to show the display text and not the cell value?
EDIT: Please take the days of week just as an easy example, the real question is how to do that when the values are some other text (Like: 1=Dog, 2=Cat".....)