| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation doesn't work
Excel 2003
DATA/VALIDATION Allow:List Source:AJ32:AJ40 When I click on a cell with this validation setting and pull down the dropdown arrow "AJ32:AJ40" appears as the only choice in the list rather than the text in that range. What am I doing wrong? Thanks in advance... Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation doesn't work
Use =AJ32:AJ40
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Bob Newman" wrote in message news:gWXOg.45523$ok5.3345@dukeread01... Excel 2003 DATA/VALIDATION Allow:List Source:AJ32:AJ40 When I click on a cell with this validation setting and pull down the dropdown arrow "AJ32:AJ40" appears as the only choice in the list rather than the text in that range. What am I doing wrong? Thanks in advance... Bob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation doesn't work
Bob,
Add an equal sign before the text. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bob Newman" wrote in message Excel 2003 DATA/VALIDATION Allow:List Source:AJ32:AJ40 When I click on a cell with this validation setting and pull down the dropdown arrow "AJ32:AJ40" appears as the only choice in the list rather than the text in that range. What am I doing wrong? Thanks in advance... Bob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation doesn't work
Thanks guys.
Bob "Jim Cone" wrote in message ... Bob, Add an equal sign before the text. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Bob Newman" wrote in message Excel 2003 DATA/VALIDATION Allow:List Source:AJ32:AJ40 When I click on a cell with this validation setting and pull down the dropdown arrow "AJ32:AJ40" appears as the only choice in the list rather than the text in that range. What am I doing wrong? Thanks in advance... Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation | Excel Worksheet Functions | |||
| Data validation with hyperlinks | Excel Worksheet Functions | |||
| Summarizing field quantities for specific records | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| Data validation does not seem to work with copy/paste | Excel Discussion (Misc queries) | |||
Linear Mode
