Hi

Is it possible to place a check on a cell that user can only enter time 1-12
hrs time format and noy 1-24 hrs format.

Example, he should be able to input from 1-12 , but not from 13 to 24

Please do not multi-post, you have responses in your other post (the one in
the excel newsgroup, not the one in the frontpage newsgroup), that you have
yet to respond too. Just curious, what is the problem if the person enters a
time in 24 hour format. If you have the cell formatted for am/pm, after the
person enters, the time will convert to 12 hour format. Without more
information, no one can really help you. And please, if you do respond to my
question, please answer in your original question, and do not continue the
double (/triple) post of the same question.
--
** John C **


"ub" wrote:

Hi

Is it possible to place a check on a cell that user can only enter time 1-12
hrs time format and noy 1-24 hrs format.

Example, he should be able to input from 1-12 , but not from 13 to 24