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.
|