See KB66342. However, that's only a partial answer--it doesn't work on all IP addresses due to the way the data is stored (bits are truncated from either end to save space -- VarDecimal maybe?) Has to be a forumla somewhere to convert it to a decimal. From there you can use Excel to convert it. Something like this (where the integer for the IP is in C2):
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.
Community Help Hub
New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.