Validation question

[ComicFly]

Is there a way to creat a drop down list where each item has a definition,
but when you pick that item only item appears. Example: 03 - Net 30 days ;
04 - Net 45 days. When you pick one of those, all you want in the cell is
the "03" or the "04". thanks . Comicfly

 

[T. Valko]

There is a sample file that demonstrates this here:

http://contextures.com/excelfiles.html#DataVal

Look for: DV0004 - Data Validation Change

 

[ComicFly]

Thanks Biff. It helps understand and use.

There is a sample file that demonstrates this here:

http://contextures.com/excelfiles.html#DataVal

Look for: DV0004 - Data Validation Change

 

[T. Valko]

Let's thank Debra for her great site!