Cell Formatting

[Guest]

I want to format a cell so that I can enter a MAC Address. I am able to use
the format 00-00-00-00-00-00 but this only allows me to input numbers. Does
anybody know how to format it so I can enter both numbers and letters? For
instance if I type in 0013A7IFE0C3, I want it to format it into
00-13-A7-1F-E0-C3. I didn't think this would be this difficult. Thanks in
advance.

 

[Dave Peterson]

Number format applies to numbers--not text.

Maybe you can use a helper column and a formula to format it pretty. Format
column A (say) as Text and then:

=left(a1,2)&"-"&mid(a1,3,2)&"-"&mid(a1,5,2)&"-"& .....