Hi,

i want to convert IP address into decimal number so that if i have IP's in Col A then i get decimal numbers in Col B.

The formula is like this:

if IP address is 192.168.1.2

then the formula to get its decimal number is: 192*16777216 + 168*65536 + 1*256 + 2

which comes out to be = 3232235778

So if A1 has 192.168.1.2 then B1 will come out to be 3232235778.

Any idea how to write above formula?

## Bookmarks