View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Keith Rathband Keith Rathband is offline
external usenet poster
 
Posts: 1
Default Converting values to text

I have a load of values which i want to convert to text, the text will
depend on the value. ie

If value=1, text = DOG
If value=2, text = CAT
If value=4, text = PIG

Thanks.