Hey everybody,

Please be aware that before I start any thread I search to my best ability to find the solution. If I start a thread, its because I had difficulties trying to find exactly what I need.

Anyways, I am working on an excel sheet where I have 5 different locations items ship to. They are written by geographic location (digits only). What I am trying to do is to have a column formatted to enter a digit and have the geographic location appear. For example:

If a user enters the number "5" on a cell the following will appear on the user hits enter: 01-005-00-744-8639
If a user enters the number "6" on a cell the following will appear on the user hits enter: 01-006-00-744-8639
If a user enters the number "9" on a cell the following will appear on the user hits enter: 01-009-00-744-8639
and so on...

This function will only be available in 1 column.

Thank you so much.