Tom

What you are asking for is what is commonly known as a "input mask" where you
enter a number and it formats as date/time.

Cannot be done in Excel without the use of formula in a helper cell or via VBA
code.

You can do this with VBA event code.

See Chip Pearson's site for code and instructions.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP

On Sun, 17 Dec 2006 22:54:01 -0800, 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