Take a look at http://www.mrexcel.com/tip029.shtml

This uses a change_event macro, which grabs your input of 1234 and
inserts the colon for you.

THe instructions on this page are fairly good.

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=571361