How to create a custom numner format for IP addresses?
 

How to create a custom numner format for IP addresses?

How to create a custom numner format for IP addresses?
 

Selection.NumberFormat = "000.000.000.000"

With selection to be substituted with any Range-object.

HTH, CoRrRan

PJ wrote:
How to create a custom numner format for IP addresses?

How to create a custom numner format for IP addresses?
 

I think you would need "000\.000\.000\.000"

in a country that uses the period as the decimal separator.

but even then that will only work correctly if you IP address has 3 digit
numbers for the last 9 digits and is entered as a number.

s = Replace("144.151.141.30",".","")
? s
14415114130
? format(s,"000\.000\.000\.000")
014.415.114.130



--
Regards,
Tom Ogilvy


"CoRrRan" wrote:

Selection.NumberFormat = "000.000.000.000"

With selection to be substituted with any Range-object.

HTH, CoRrRan

PJ wrote:
How to create a custom numner format for IP addresses?