Format Cell contents as I.P. address

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
 
G

Gord Dibben

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
 
L

Lionel B. Dyck

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...
 
P

Pete

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
 
Top