Thanks for trying, but I am trying to do this in an environment where I can't
install a program on my own desktop, never mind on the dozens that I would
need to install this plug-in for it to work for all those who would need to
have it. Users here don't have admin rights.

"Niek Otten" wrote:

Look he

http://xldynamic.com/source/xld.QDEDownload.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Nevets" wrote in message ...
|I am creating a workbook for many users, so I would like to make it as "idiot
| proof" as possible. In several of the cells, I want users to enter time in a
| 24 hr format. If I format the cell to accept "hh:mm" times, then the users
| have to enter it exactly that way for it to be accepted. Is there a way to
| set up the cell so that if they enter "hhmm", or "hh.mm", (or even "hmm" if
| the time being entered is before 0959), the program will convert it to
| "hh:mm" format when they tab out of the cell?
| For example, user wants to enter 08:00 hrs; so if they type 08:00, 08.00,
| 0800, or 800 in the cell, when they tab out, it will convert to 08:00.
| I also want to do something similar with a date field. MS Word does
| something like this with text form fields; I can set up a text field such
| that if someone enters "sep 7 07" then tabs out of the field, it will be
| changed to "Friday September 7, 2007".
| Can I get Excel to do what I want?