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