Validation doesn't work

B

Bob Newman

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
 
B

Bob Phillips

Use =AJ32:AJ40


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
J

Jim Cone

Bob,
Add an equal sign before the text.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Bob Newman"
<[email protected]>
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
 
Top