didnt't know what to search to find it on the forum, so here is the
problem.


I need to insert colon to places to the left, like "X12345"="X123:45",

and "X1234"="X12:34" etc.

I'm sure it's a simple answer for you guys, but not for me


--
Phoenix
------------------------------------------------------------------------
Phoenix's Profile: http://www.excelforum.com/member.php...fo&userid=2921
View this thread: http://www.excelforum.com/showthread...hreadid=507993