change display value but leave entered value same

Hi

I would like to be able to enter numeric values into cells and have them display text without changing the numeric value. Is this at all possible?

Enter 1 into a cell which intern displays Yes but when the cell is selected 1 is the true value.

I did find a code that was similar to to what I wanted, however it changed the cell value to the displayed value.