S
Steve Andrews
Terry,
Instead of having Excel convert the number to a string
within the same cell at which the number was entered,
other approaches seem more straightforward.
1) If you use a separate cell/column for the numeric
entry, it is simple with a VLOOKUP() to have the string
appear in ANOTHER cell. In other words, enter the number
in one cell and produce the string in another.
2) Simply use a drop-down list by selecting the cell and
choosing Data\Validation. With a validation type
of "list" and the data range entered at the prompt, the
user selects from the list of strings with no number code
used.
I hope one one these approaches can fulfill your needs.
Steve
Instead of having Excel convert the number to a string
within the same cell at which the number was entered,
other approaches seem more straightforward.
1) If you use a separate cell/column for the numeric
entry, it is simple with a VLOOKUP() to have the string
appear in ANOTHER cell. In other words, enter the number
in one cell and produce the string in another.
2) Simply use a drop-down list by selecting the cell and
choosing Data\Validation. With a validation type
of "list" and the data range entered at the prompt, the
user selects from the list of strings with no number code
used.
I hope one one these approaches can fulfill your needs.
Steve