When I enter in a #, I want it to enter in the text instead of the number.
For example: 1=Corp; 3=BPGS; 5=Rodney. I want this to apply to an entire
column so that I can just go down, enter in the number and the word will
enter in.

Pls help