Cell Formated for MAC address

B

Bob

Hi,

Is there a way to format a cell to display twelve alphanumeric characters to
look like a MAC address?

For example, if the cell contents are: 0003FF411153
I want it to display like this: 00-03-FF-41-11-53

If a MAC address were all numeric's, the following would work::
##"-"##"-"##"-"##"-"##"-"##
But because MAC addresses have characters A-F, this won't work for me.

I tired using: @-@-@-@-@-@ but that didn't work either.
Any thoughts?

Thanks!
 
D

Dave Peterson

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)&"-"& .....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Routers & MAC Addresses 2
Routers & MAC Addresses 1
Formatting Cells - Hex Values 3
Getting MAC Address 3
formatting MAC Addresses 2
How to get MAC address from command line / batch file in Vista? 21
Cell Formatting 1
How to format a cell to reflect a NIC's MAC Address ? (put in dash 2

Top