title: Get decimal value of an ipv6 address
body: <p>Could anyone help me with the formula to calculate the decimal value of an IPv6 address? </p>
  
  <p>I need to put the formula in VBA to make a custom excel formula. I know the formula for IPv4 and I have read it is similar but I can not seem to figure it out. I need this to be able to map a IPv6 address to a range in the <code>ip2location</code> CSV.</p>