Formatting a cell

[Guest]

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

 

[Scott]

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

 

[Geoff Ness]

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.

 

[Gord Dibben]

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