Not without some event code or a helper cell with a formula.

See Chip Pearson's site for code.

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


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 08:30:02 -0700, jshehan
wrote:

I am having some what the same problems, however I am wanting the cell to
display 24hr time as ie...13:30 with the colons, and without actually keying
in the colon when entering in the numbers as 1330. Is there any way that it
will automatically insert the colons without keying them in????