Has anyone found a formula in excel to convert the origIpAddr in the CRD files in to a readable ip address.
I have found this
Step 1 Convert the database display (-1139627840) to a hex value.
The hex value equals 0xBC12A8C0.
Step 2 Reverse the order of the hex bytes, as shown below:
CO A8 12 BC
Step 3 Convert the four bytes from hex to decimal, as shown below:
192 168 18 188
Step 4 The IP address displays in the dotted decimal format:
But am hoping someone has created a formula to get around this.