IP2Location Decimal IP Conversion Excel Add-In
================================================

IP2Location Decimal IP Conversion Excel Add-In is a free add-in that enables end-users to convert a IPv4 address into a proper address or vice-versa. 

Last Edited Date: 2013-10-23

REVISIONS
  Version 1.0
    * Initial release of the IP2Location Decimal IP Conversion Excel Add-In.

SUPPORTED MICROSOFT OFFICE VERSION

1) Microsoft Office 2007 (Microsoft Windows only)
2) Microsoft Office 2010 (Microsoft Windows only)
3) Microsoft Office 2013 (Microsoft Windows only)


INSTALLATION INSTRUCTIONS
Microsoft Office 2010 and Microsoft Office 2013
1) Make sure you have closed all open Excel Windows before continuing to the next step.
2) Create a new folder, e.g. C:\ip2location-ip-conversion or anything you want.
3) Copy the "ip2location-ip-conversion.xlam" to the Step 1 folder.
4) Open Microsoft Excel, navigate to Options->Add-Ins.
5) On the Add-Ins tab, select Excel Add-ins from the drop down list of Manage option (Excel Add-ins should be selected by default)
6) Click Go. A new window with list of Add-ins should appear.
7) Click browse and select the "ip2location-ip-conversion.xlam" and click Open. 
8) The Add-ins are now installed and available to use.

Microsoft Office 2007
1) Make sure you have closed all open Excel Windows before continuing to the next step.
2) Create a new folder, e.g. C:\ip2location-ip-conversion or anything you want.
3) Copy the "ip2location-ip-conversion.xlam" to the Step 1 folder.
4) Open Microsoft Excel, click the Office icon on the top left and click Excel Option.
5) On the Add-Ins tab, select Excel Add-ins from the drop down list of Manage option (Excel Add-ins should be selected by default)
6) Click Go. A new window with list of Add-ins should appear.
7) Click browse and select the "ip2location-ip-conversion.xlam" and click Open. 
8) The Add-ins are now installed and available to use.


USAGE EXAMPLE
1) Open a new Excel worksheet.
2) In cell A1, type 8.8.8.8 and in cell B1, type =IPAddress_IPNumber(A1)
3) You should now see the B1 cell shows 134744072.
4) In cell D1, type 134744072 and in cell E1, type =IPNumber_IPAddress(D1)
5) You should now see the E1 cell shows 8.8.8.8

AVAILABLE FUNCTIONS
IPAddress_IPNumber(strIP)
  Return value: IP numbers.

IPNumber_IPAddress(double)
  Return value: IPv4 IP address.
  