View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do I make 1 = "yes"?

There is this ancient Format feature where you can specify up to 3 conditions plus an Else branch.

FormatCellsNumber tab, Custom. In the Type box, enter something like

[=1]"yes";[=2]"Not enough info";"no"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"lindasuenwh" wrote in message ...
|I have looked all over and have to finish this report asap. Help is not
| helping. How do I format a cell to return a word when I input a number? For
| example, "2" = "Not enough info" or "0" = "No"?
| Thanks -
| Excel newbie