No way to enter times without the colon unless you use event code.

Chip Pearson has that code.

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


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 20:05:02 -0700, saffiyu
wrote:

I am doing my time sheet, as it is a share resoure, other colleagues will use
it as well. Try to save our time, we will type 1630 instead 16:30
how can i set up the Excel so it will auto turn the 1630 as 16:30 time
format as i need this format for the formular.

many thanks