Can this only be used with two numbers? What if 1 & 2 = final and 3 & 4 =
rough?
thanks - just learning

dp

"Bob Umlas, Excel MVP" wrote:

Use a number format (Format/Cells, click Custom category):
[=1]"final draft";[=2]"rough draft";General


"B-positive" wrote:

Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"