User inout in 12 hrs format

[ub]

Hi

I want the user to input time in one of the cells in 12 hrs format.
Example, user should only be able to enter 11:00 am or 11:00 pm.
Is there any way to do this.

Thanks

 

[Tom [Pepper] Willett]

Try an Excel newsgroup. This is for FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: Hi
:
: I want the user to input time in one of the cells in 12 hrs format.
: Example, user should only be able to enter 11:00 am or 11:00 pm.
: Is there any way to do this.
:
: Thanks
:

 

[md Webs Unlimited]

Same as before - do you have the correct newsgroup - this is the FrontPage
web design newsgroup.

--
Mike - FrontPage MVP '97 - '02
Expression Tools & Addin
http://www.j-moves.com
http://www.panemanager.com
FrontPage Tools & Addin
http://www.jbots.com
E-Commerce
http://www.candypress.com