View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E.[_2_] Charlotte E.[_2_] is offline
external usenet poster
 
Posts: 70
Default Leading zeros in IP address?

If I have a string containing a given IP address - it could be any IP
address, like:

1.222.33.004

What would be the smartest/shortest code, to make sure that all subnets have
leading seros, like:

001.222.033.004



TIA,