Decimal IP to Dotted Quad

[mattmac]

Hi Guys,
I've got a list of IP addresses in a column in decimal format i.e. 168488278 and I want to convert them to Dotted Quad i.e. xxx.xxx.xxx.xxx

There are far too many to do by hand and I can't figure it out so was wondering if you could give me some help?

Thanks in advance

 

[Andrew Poulsom]

Welcome to the Board.

If A1 contains 168488278 try the formula:

=TEXT(A1,"###\.###\.###")

 

[mattmac]

Hi Andrew,
Thanks for the quick reply.

I think you misunderstand me - I probably used a bad example of decimal IP.

168488278 does not translate to 168.488.278.x

It actually translates to 10.10.237.86 (try it out in http://www.kloth.net/services/iplocate.php)

Cheers

 

[Andrew Poulsom]

Sorry about the misunderstanding. I found a couple of functions on Google:

http://www.freevbcode.com/ShowCode.asp?ID=938

If you still need help post back.

 

[mattmac]

That's what I was looking for Thanks

 

[bubba2413]

This actually goes both ways: IPv4 -> Decimal IP -> IPv4

https://drive.google.com/file/d/0B8jeLxypP81_N0FSQXRMdWpZZWs/view?usp=sharing

 

[bubba2413]

The FORMULAS shown here go from IPv4 dotted decimal to Decimal IP and back.

going back is not pretty, and I can't take credit for the really, really short and clean conversion from Dotted to Decimal But the reverse is all mine. If anyone can shorten it nicely like the one from IPv4->Dec that would be AWESOME

OK. and finally... Why formula's instead of functions? because SOME customers have what is effectively a complete BAN on any 'embedded code'. This includes macros and embedded functions. and since the customer's pay the bills... we have to play by their rules or not at all.