User inout in 12 hrs format

  • Thread starter Thread starter ub
  • Start date Start date
U

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
 
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
:
 
Back
Top