Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel Validation picklist
I have an Excel list and for one "field" (column) I want to create a
dropdown picklist. The pick list choices are 1, 2, 1/2. These refer to clinical trial phases so the items in the list will be designated as Phase 1, Phase 2 or Phase 1/2 (both phases) When I create my pick list as 1, 2, 1/2 in the validation menu it creates a picklist whose choices are 1, 2, and 2-Jan. Preceeding the picklist values with a single quote will prevent the 1/2 from showing up in the list as 2-Jan but then when it is chosen in the list the field shows an type error in that cell. Can anyone advise me of a work-around? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel Validation picklist
Hi there,
If you are keeping this list in an associated table as three options, just use "1,2,3". When you check against your phases (or use them specifically), instead use "Phase 1", "Phase 2" and "Phase 1 and 2". This is more specific and will not be construed as a date to Excel (as it is with the "/" key). HTH -- Regards, Zack Barresse, aka firefytr wrote in message oups.com... I have an Excel list and for one "field" (column) I want to create a dropdown picklist. The pick list choices are 1, 2, 1/2. These refer to clinical trial phases so the items in the list will be designated as Phase 1, Phase 2 or Phase 1/2 (both phases) When I create my pick list as 1, 2, 1/2 in the validation menu it creates a picklist whose choices are 1, 2, and 2-Jan. Preceeding the picklist values with a single quote will prevent the 1/2 from showing up in the list as 2-Jan but then when it is chosen in the list the field shows an type error in that cell. Can anyone advise me of a work-around? |
#3
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
MS Query from Excel - Preserving formatting, validation and Commen | Excel Discussion (Misc queries) | |||
Passwords and Encryption for Excel 2003 for Validation Purposes. | Excel Discussion (Misc queries) | |||
Using Data Validation on an Excel web page | Excel Discussion (Misc queries) | |||
Data Validation Excel 97 | Excel Discussion (Misc queries) |