Data Validation without using List feature
Can you restrict them to a 12 hour window so there is no ambiguity?
The cell doesn't store the AM/PM. It is stored a decimal value between 0
and 1. 0.25 is 6 AM, .5 is 12 Noon, .75 is 6 PM.
So validation isn't going to be able to test on an AM or PM entry in the
cell because there won't be one - unless you format the cell as Text, then
it will be more difficult to work with as a date to do calculations.
--
Regards,
Tom Ogilvy
"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
|