That's very cool Nick, and certainly a keeper. It does exactly what the OP
asks for, however, it will also return a "no" for any other number besides 0,
1, or2 in my XL97. Is there a way to change it to allow the other numbers to
show as typed?

Vaya con Dios,
Chuck, CABGx3



"Niek Otten" wrote:

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