Steve,

Can you not use the data validation and input the full text list, but
resize the cell on the book so it is only big enough for 2 letters?

Duncan


Steve wrote:

Hi

I'm kind of hoping that not toom much programming is required here.

What I am trying to do is have a drop down list (not on a form but using the
validation option) where the options are for example:

AN - Delivery
CU - Customer collection
etc

However, what I want to appear in the cell is just the first two letters. Is
this possible?

Many thanks

--
Steve R