Generally speaking users find it somewhat disconcerting if what they entered
gets changed up on entry. You get lots of "Well thats not what I entered...".
As a suggestion use a vlookup in another cell to reference the value of the
drop down to the code you want to use. That way your user interface is simple
and intuitive and the back end uses the codes you need it to...