How can I format tcp/ip addresses in Excel?

J

JimB

Is there a template or custom format out there somewhere (I'm an obvious
Excel rookie)? I have searched and am now officially blue-in-the-face. I
would like to be able to format a column to tak the ip address and sort,
filter, etc. Some networking genius must have done this at some time.
Thanks in advance for pointers!
 
D

Dave Peterson

If you enter each IP address as 12 digits--no dots at all, you can give the
column a custom format of:

000\.000\.000\.000

Remember, you'll have to enter the IP address as:

012013001003
to see
012.013.001.003
 

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

Sorting IP Addresses in Excel? 3
How can I change like this? 3
How to create an Input Mask (and necessary code) for an IP Address 2
Hopw can I Reverse-DNS lookup an IP Address? 3
CFP: 8th International Workshop on Critical InformationInfrastructures Security (CRITIS 2013) 0
8th International Workshop on Critical Information InfrastructuresSecurity (CRITIS 2013) 0
How can I convert conditional formatting into explicit formatting? 0
how to sort number properly in excel? 5

Top