Decimal IP to Dotted Quad

mattmac

New Member
Joined
Apr 23, 2010
Messages
10
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
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to the Board.

If A1 contains 168488278 try the formula:

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

mattmac

New Member
Joined
Apr 23, 2010
Messages
10

ADVERTISEMENT

That's what I was looking for Thanks
 

bubba2413

New Member
Joined
Nov 8, 2010
Messages
25
This actually goes both ways: IPv4 -> Decimal IP -> IPv4

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

bubba2413

New Member
Joined
Nov 8, 2010
Messages
25
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,630
Messages
5,597,277
Members
414,133
Latest member
lucid33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top