Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


tdgeek

30048 posts

Uber Geek
+1 received by user: 9455

Trusted
Lifetime subscriber

#279979 20-Nov-2020 09:04
Send private message

I need to sort thousands of IP addresses. xxx.xxx.xxx.xxx for audit purposes

 

But the issue is they stay in this order re the last 3 digits as below. I want them in strict numerical order 1  2  3  4  5  6  7  8  9  10 11 12 and so on

 

Ive tried all manner of options in Excel, including 000.000.000.00 custom format to no avail

 

Any ideas? Its probably easy but I can't find it

 

 

 

 

 

0

 

1

 

10

 

100

 

101

 

102

 

103

 

104

 

105

 

106

 

107

 

108

 

109

 

110

 

11


Create new topic

This is a filtered page: currently showing replies marked as answers. Click here to see full discussion.

kiwiharry
1064 posts

Uber Geek
+1 received by user: 476

ID Verified
Subscriber

  #2607316 20-Nov-2020 09:14
Send private message




If you can't laugh at yourself then you probably shouldn't laugh at others.


Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.