I am trying to see if there is a way to change text entered into a cell into
a number based on the text entered. As an example, an airport code of MSP
would need to be changed to a store number 510. Is there a way to do this in
Excel 2000? There are about 25 codes that could be entered and of course 25
numbers.

Any suggestions would be appreciated.

--
Brooks W.