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?
|