Use a different column (A:D) for each octet.

Then use a formula in E to combine the string.
=a1&":"&b1&":"&c1&":"&d1
or
=hex2dec(a1)&":"&hex2dec(b1)&":"&hex2dec(c1)&":"&h ex2dec(d1)
or
=text(hex2dec(a1),"000")&":"
&text(hex2dec(b1),"000")&":"
&text(hex2dec(c1),"000")&":"
&text(hex2dec(d1),"000")

If you use the formulas that have =hex2dec() in them, remember that you have to
have the analysis toolpak installed (xl2003 and below).




richdsn2 wrote:

I want to enter a series of 50 mac addresses into an Excel spreadsheet. How
do I format the cell so that all I have to do is enter the hexidecimal
numbers, and Excel will automatically enter a colon between each set of two
numbers?

--

Dave Peterson