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!