Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2006
    Location
    Gtr London, England
    Posts
    256
    Thanks
    2
    Thanked 0 Times in 0 Posts

    IP Address to Hexadecimal

    Hi,

    Does anyone have any idea how to convert a decimal IP address to a Hexidecimal IPX address, or can suggest where I can find a utility to do this?

    Any help will be grately appreciated.

    Regards.
    Lee

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IP Address to Hexadecimal

    If you have Excel, you can use the attached workbook (I didn't devise the formula myself, I found it here)
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    Aug 2006
    Location
    Gtr London, England
    Posts
    256
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: IP Address to Hexadecimal

    Hi Hans,

    Thanks for the attachment, however when I put the ip address in B1 and return, B2 doesnt show the IPX number but shows '#NAME?'......Is there something Im doing wrong?

    Regards.
    Lee

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IP Address to Hexadecimal

    Oops, I should have mentioned that you must have Analysis ToolPak installed:
    - Select Tools | Add-Ins...
    - Tick the check box "Analysis ToolPak".
    - Click OK.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2006
    Location
    Gtr London, England
    Posts
    256
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: IP Address to Hexadecimal

    No problem, many thanks for your help Hans.

    Cheers.
    Lee

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •