Hello-

Without invoking something more technical, you can select the cell(s) and go
to DataValidation and choose what type of entry be allowed in the field.
Format the cell in the manner you wish to have the date or time expressed.

HTH |:)

"HJC" wrote:

In Access, I can set up a field that "forces" the user to enter info - a
date, for example - in a certain way, such as 25 Jan 05 or enter time as
12:15 AM. Is there a way that I can "force" this in excel?

Thank you.