How to create a custom numner format for IP addresses?

's Computer Specifications

's Computer Specifications

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?

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create a custom number format in Excel using a symbol?	=?Utf-8?B?bWJ1Y2tyZWxs?=	Microsoft Excel Misc	2	26th Jul 2006 12:49 AM
Create custom text format?	Jaffo	Microsoft Excel Misc	7	27th Jan 2006 11:38 PM
Is it possible to create your own custom format?	Scott Steiner	Microsoft Excel Misc	5	22nd Nov 2005 05:46 PM
Is there a way to create a custom date format?	=?Utf-8?B?TE1pbGxlcg==?=	Microsoft Outlook Discussion	6	11th Nov 2005 03:09 AM
How do I create a custom Number format for Dozens and Pieces		Microsoft Excel Setup	0	26th Oct 2004 09:54 PM