Tech Tip - CA Risk Authentication : IP Address from Decimal conversion in Excel

Document created by renar01 Employee on Aug 19, 2015Last modified by kristen.palazzolo on Dec 17, 2016
Version 3Show Document
  • View in full screen mode

After exporting data from ARRFUNTRUSTEDIPLIST table, IPConversion plugin can be used to convert IP Address from Decimal in Microsoft Excel. This will be helpful for Support Engineer to analyze customer big data easily.

 

FTP location to download add-in is http://files.weenig.com/tools/IPConversion.xlam

 

To activate an Excel add-in,

1. Go to File tab -> Options -> Add-Ins category

2. In Manage box -> Excel Add-ins -> Go. The Add-Ins dialog box appears.

3. In Add-Ins available box, use 'browse' option to load the add-in file IPConversion.xlam into Excel.

Attachments

    Outcomes