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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

network printer to email 2
i.p address 1
Copy and paste the cell boarder only not the content 3
any sample coding for capture I.P. address ? 1
No Auto IP Retrieval 4
Prepend cell contents with adjacent cell? 3
I.P. ADDRESSES 2
somewhat complicated conditional formula 2

Back
Top