If you mean that you want this to happen as you type, then you can
make use of Tools | Autocorrect, and in the Replace box enter 1 and in
the With box put "needs to call", and so on for the other numbers.
However, you must remember to get rid of these definitions if you want
to use Excel normally.
If you mean that you already have these number codes, and you want to
convert them into the appropriate phrases in a separate column, then
you will need to define a little table of the numbers and the phrases,
and then you can use a VLOOKUP formula. Depending on how many codes
you have, and what they are, you could use LOOKUP (without a table) or
CHOOSE - all of these are described in XL Help.
Hope this helps.
Pete
