Create custom text format?

Originally Posted by BekkiM

Try this:

1) Highlight the column
2) Select Format | Cells
3) Pick "Custom"
4) In the "Type" box, enter 00-00-00-00-00-00

I tried this, but it had no effect on the format at all.

I used a fake ethernet address of a1b2c3d4e5f6, and it stayed exactly like that when I put in your suggested solution.

Hi,

Kostis has supplied the correction necessary for my earlier formula
(thanks, Kostis) - sorry, I rushed it.

Custom formatting won't work because you are dealing with text values.

Pete

Thanks a lot everyone!

That last one worked perfectly for me!

I really appreciate the help - this'll save me a lot of manual data massaging!