He's looking for a method to change IP addresses into 12 character dotted
quads with leading zeros. All addresses will be in the form nnn.nnn.nnn.nnn
with leading zeroes in each group of 3. So, 1.22.33.4 becomes
001.022.033.004. Probably best handled by VBA


"Don Guillett" wrote in message
...
more examples


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"metelcom" wrote in message
...
I want a formula that will create an IP address that can be sorted
properly

example:

Row A Row B
11.23.45.678 011.023.045.678