come to think of it, change the "," to "." everywhere in the formula

"bj" wrote:

try 000","000","000","000
with 0 instead of #
however this will only give you the leading zeros in the fisrt section, all
the rest need the zeros added
if you have the sections in different cells (A1:D!)you coul duse
=text(A1,"000")&","&text(B1,"000")&","&text(C1,"00 0"&","&text(D1,"000")
this will give you the leading zeros for each section

"Pete" wrote:

I replied to the following thread: http://tinyurl.com/2ky6vm, but it
was a month old and I've gotten no replies. Therefore, I am creating
this new post to address the matter.

This has been asked previously, but I have never seen a response that
I can understand or apply. I'm using MS Excel 2003. I frequently
need to enter IP addresses into a product called Remedy, and this
product requires that entries contain 12 numerals in IP Address
entries. It would be a huge timesaver to be able to take my lists of
IP Addresses and paste the segment IP addresses into worksheets that
convert them to Remedy Format (with Leading Zeros where necessary.) I
tried the number format ###"."###"."###"."### but this will not add
the leading zeros to IP addresses entered without them.

Is there a means to accomplish this without manually entering the
leading zeros? (unrealistic)
I have minimal scripting experience. Thanks in advance.

Pete Marion
Commonwealth of Pennsylvania
Information Systems
Technology Engineering
Security Architecture