Format Cell contents as I.P. address

  • Thread starter Thread starter Lionel B. Dyck
  • Start date Start date
L

Lionel B. Dyck

Is there a way to force the contents of a cell to conform to the format of an
I.P. address (e.g. nnn.nnn.nnn.nnn) ?

I looked in the tutorial format cell and found custom but no useful tutorial for
how to do it.

Thanks
 
Custom ###"."###"."###"."###

i.e. 123456789123 will be formatted as 123.456.789.123

Just as long as you realize that the number is still the original number you
entered.


Gord Dibben MS Excel MVP
 
Thank you

Gord said:
Custom ###"."###"."###"."###

i.e. 123456789123 will be formatted as 123.456.789.123

Just as long as you realize that the number is still the original number you
entered.


Gord Dibben MS Excel MVP
Click to expand...
 
Is there a "simple" way to add leading zeros to ensure all IPs consist
of 12 digits? Remedy requires this format - it would be a huge
timesaver.

Thanks in advance
 
Back
Top