automatic format of colon


how can i format the cell with automatic colon in in every second
alphanumeric

when i type>>>>>>>>>>>>>> 00ED078125EA
FORMAT MUST BE THIS >>>>>>> 00:ED:07l:81:25:EA


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23851
View this thread: http://www.excelforum.com/showthread.php?threadid=491717

.

Relevant Pages

  • Re: contains formula
    ... xtrmhyper's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23851 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: countif condition
    ... i wan to count all b=1 with c=1&2 ... xtrmhyper's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23851 ... Prev by Date: ...
    (microsoft.public.excel)
  • hidden formula
    ... tnx in advance ... xtrmhyper's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23851 ... Prev by Date: ...
    (microsoft.public.excel)
  • Easy Formula?
    ... Theres Any Easy Formula? ... xtrmhyper's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23851 ... Prev by Date: ...
    (microsoft.public.excel)
  • problem adding
    ... My spread sheet ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)