I want to create a key that converts numbers into words. For instance I want
1 to equal "needs to call" so that when I enter 1 those words come up. Is
that possible?

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

On Jan 9, 7:12*pm, OfficeMaven
wrote:
I want to create a key that converts numbers into words. For instance I want
1 to equal "needs to call" so that when I enter 1 those words come up. Is
that possible?