M MONDLOC New Member Joined Jan 23, 2004 Messages 4 Jan 23, 2004 #1 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
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 MrExcel MVP, Junior Admin Joined Aug 1, 2002 Messages 55,381 Office Version 365 Platform Windows Jan 23, 2004 #2 There was quite a lengthy discussion on this the other day. See: http://www.mrexcel.com/board2/viewtopic.php?t=75243&highlight=colon
There was quite a lengthy discussion on this the other day. See: http://www.mrexcel.com/board2/viewtopic.php?t=75243&highlight=colon