Data Validation without using List feature
Just for clarification, Doug is talking about entering the Text AM or PM in
a separate cell. That may very well be what you were asking. I was
answering in the context of entering a time in a cell and specifying AM or
PM as part of the time value.
--
Regards,
Tom Ogilvy
"Doug Glancy" wrote in message
...
You can use a list but uncheck the "In Cell Dropdown" box.
Or you could use Custom instead of list and use this formula:
=OR(A1="AM",A1="PM")
hth,
Doug
"Connie" wrote in message
oups.com...
I am trying to validate data using the Data Validation interface. I
want to make sure the user enters either AM or PM, but I don't want to
use a list. I want the user to type the data in. Is there a way to do
this? Thanks.
Connie
|