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

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

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

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