You can also use the custom format

d/mm/yyyy h:mm:ss AM/PM

Just type this in to the custom format box in the Format Cells dialog.


Scott wrote:
This isn't what you're asking for, but.... are you looking to ensure
they type in a date value?

If so, may I suggest you look at Data Validation?

To set it up so they can only enter dates in a given cell, choose:

Data - Validation

Then, on the window that pops up, change Allow: to 'Date', then choose
what date ranges you would like to allow. By way of an example, you
can set the Data: to 'greater than' and then set Start Date: to some
date.

Then hit OK.

Scott

tom wrote:
I am looking to "custom format" a cell to minimize (or eliminate) data entry
errors the cell must be formatted for: (12/14/2006 8:00:00 AM) entries.

TFTH,
Tom