Thread: Force users to enter a range of cell in dd/mm/yy hh:mm format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default Force users to enter a range of cell in dd/mm/yy hh:mm format
You could use Date | Validate since 10/5/09 10:00 is a valid 'date' while
10/5/09 10.00 is not
The Validation dialog requires you enter start and end date but you can
enter some dummy values if this is unimportant to you
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"TATA STEEL" wrote in message
...
I have created a template which is filled by users for date & time. Since
users are novice, can I force users to enter the cell values only in
dd/mm/yy hh:mm format?

For ex if a user wants to enter 10th May 09 10:00Am & by mistake he types
10/5/09 10.00 ( uses . instead of colon) excel misunderstands.



Reply With QuoteReply With Quote