View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
CoRrRan CoRrRan is offline
external usenet poster
 
Posts: 19
Default 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?