Hi B,

You could use Auto Correct replace text as you type.
Just use an odd key combination that you are not
likely to use anywhere else e.g.
|1 |2 |3
or maybe
...1 ..2 ..3
or
zz1 zz2 zz3
or......whatever!

HTH
Martin


"B-positive" wrote in message
...
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"