TIME

[MONDLOC]

I am inputting a lot of miltary time cells. Is there a way that i can set it up so that the colon will automatically appear when I enter the four digits? Thanks

 

[Joe4]

There was quite a lengthy discussion on this the other day. See:

http://www.mrexcel.com/board2/viewtopic.php?t=75243&highlight=colon