This is my first post, so I trust I make myself clear!

I am entering a large amount of data into a spreadsheet. One of the rows is titled 'Operative', where a staff name is entered. Would it be possible if I were to assign each member of staff a number (e.g. 04), when I enter that number into the cell, it automatically changes that number to the staff member's name (e.g. Mark).

I hope you understand what I mean, and can see the benefits of this, saving me typing more characters than necessaries into each row!

Any help would be appreciated.

Andy