What happens when 19216801represents 19.216.80.1, or there are more than 8
digits?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CDiddy" wrote in
message ...

Hi All,

I assume there is a quick and easy formula for this, but the only way I
have figured out how to do it requires three forumlas in 3 seperate
cells.

Basically, I need to turn a 8 digit number into an IP address.

So, Say in cell A1 I have 19216801. I need a formula that will make
cell A2 read 192.168.0.1

I assume that theres an easy way to do this, but I've yet to figure it
out.

Your help will be much appreciated!


--
CDiddy
------------------------------------------------------------------------
CDiddy's Profile:
http://www.excelforum.com/member.php...o&userid=29492
View this thread: http://www.excelforum.com/showthread...hreadid=491925