How can I format tcp/ip addresses in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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? 6
Funciton to subtract and add a digit to an IP address format? 6
Format a Cell in Excel as an IP address field 1
TCP / IP not available 1
How to block TCP/IP address? 6
email address in excel 3
Have static IP address, but tcp/ip property page always shows “Obtain IP address automatically”, Win 16
Changing source IP address of TCP/IP Packets 4

Back
Top