Today I had to decommission a Windows Server which was running a DHCP role. The client has a Meraki firewall and on the firewall is an option to import all the IP reservations from a formatted CSV: “That’s great!”, I thought. I can get all ~100 reserved IPs in at once as long as I format the exported table that same way! It’s too bad that the windows server “export” option for the DHCP role left me with this mess for MAC format: So naturally I looked for a way to quickly change this format into one that the Meraki dashboard would accept.

• Mac Address Lookup
• Mac Address Example

First open Excel and make sure the MACs are all in a column. Next open the Visual Basic editor in Excel (ALT+F11) and go to Insert > New Module Then Paste this into the window that comes up.

I am putting together a Network Table containing the details of all of my Network Devices and Connections. I need this because every time I need service, the first thing they ask me is the Model Number and Serial Number of my Modem, which is buried deep inside of a Wall Closet; or, they ask me for an IP or MAC Address which I cannot possibly memorize. So, I need to mix Number Formats with Text Formats for the following Example Cell items: 1. MAC Address: 00:1R:54:C8:CD:30 2.

Here is a macro that returns both the IP address and MAC address for the NIC installed on your computer. The information is displayed in dialog box in normal address format. Please Login or Register to view this content.

IP Address: 250.250.250.58 3. Part Number: 515291-017-00 Is there a way to mix these formats, as shown above? I cannot find it anywhere. From what I can find, Numbers only allows Text OR Number Formats, but no mixing of the two formats. Hi yo', The three examples can each be easily handled in a cell formatted to Text, and a cell left on 'Automatic' will automatically show them as Text. There's nothing particularly numeric about any of these, despite the fact that each uses numeric characters.

Mac Address Lookup

Functionally, they're simply labels, used in indexing, but not used in any calculations. The only instances in which I can see Automatic formatting failing are in the cases of serial numbers and the like containing either no non-numeric characters or containing only the letter E. Numbers will see these as 'numbers' and will format them as such. Short ones will be aligned right, rather than left like the three examples. Long ones (over 11 digits) will be rounded and displayed in scientific notation. Those containing an E will be interpreted as being written in scientific notation and displayed as such.

Mac Address Example

In these cases, you can force Numbers to see the entry as Text by starting the entry with a single quote. Example: 98765 displays as 1.23457E+14 (scientific notation) '98765 displays as 98765 Regards, Barry. Hi yo', The three examples can each be easily handled in a cell formatted to Text, and a cell left on 'Automatic' will automatically show them as Text. There's nothing particularly numeric about any of these, despite the fact that each uses numeric characters.

Functionally, they're simply labels, used in indexing, but not used in any calculations. The only instances in which I can see Automatic formatting failing are in the cases of serial numbers and the like containing either no non-numeric characters or containing only the letter E. Numbers will see these as 'numbers' and will format them as such. Short ones will be aligned right, rather than left like the three examples. Long ones (over 11 digits) will be rounded and displayed in scientific notation. Those containing an E will be interpreted as being written in scientific notation and displayed as such.