Custom Cell Format Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I format a cell in Excel 2003 that will show any IP address as four
groups of three numbers separated by periods?

For example, I would want 123.98.0.876 to appear as 123.098.000.876. The
most extreme example being that I would want 1.1.1.1 to show as
001.001.001.001.

I looked in the customer formatting box in Excel, but none of the formatting
options allowed what I need.

Thanks in advance.
 
Formatting won't help.

You could put each of the numbers in a separate cell (say B1:E1) and put a
formula like this in A1:
=text(b1,"000.")&text(c1,"000.")&text(d1,"000.")&text(e1,"000")
 
Back
Top