View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Validation drop-down boxes

So back to square one which was to have the 01, 02, 03 show a description
when selected.

I think either a helper cell with VLOOKUP or my event code.


Gord

On Sun, 20 Sep 2009 13:21:50 -0400, "Rick Rothstein"
wrote:

You could make your entries with a leading apostrophe (eg, '01) in the cells
and then a Custom Format like this...

@" - Swimwear"

The only problem is that the DV List will only show the 01 and not the
formatted text part.