Microsoft::Excel::Formula::Sort by IP Number

I hate that editors, excel, SQL reports, etc will not sort properly by IP address.
This great Excel formula will calculate a unique integer value for an IP address to allow sorting on that value:


=((VALUE(LEFT(A2, FIND(".", A2)-1)))*256^3)+((VALUE(MID(A2, FIND(".", A2)+1, FIND(".", A2, FIND(".", A2)+1)-FIND(".", A2)-1)))*256^2)+((VALUE(MID(A2, FIND(".", A2, FIND(".", A2)+1)+1, FIND(".", A2, FIND(".", A2, FIND(".", A2)+1)+1)-FIND(".", A2, FIND(".", A2)+1)-1)))*256)+(VALUE(RIGHT(A2, LEN(A2)-FIND(".", A2, FIND(".", A2, FIND(".", A2)+1)+1))))

And to turn that number back into an IP number:


=IF(B2<>"", CONCATENATE(INT(B2/256^3), ".", INT(MOD(B2, (256^3))/(256^2)), ".", INT(MOD(MOD(B2, 256^3), 256^2)/256), ".", MOD(MOD(MOD(B2, 256^3), 256^2), 256)), "")

Thanks to Matt Schuster, quoted at www.mvps.org

Operational limits of Word Documents

MS KB 211489
Very interesting:
The maximum file size is limited to 32 MB for the total document text only and does not include graphics, regardless of how the graphics image is inserted (Link to file, Save with document, or Wrapping style) into the document. Therefore, if the file contains graphics, the maximum file size can be larger than 32 MB.

Test drive the 2007 Microsoft Office release - Help and How-to - Microsoft Office Online: "Test drive the 2007 Microsoft Office"
Test drive Office 2007 over the internet without installing it.

MS Office::Browser Window

It is a pain for Office documents to open in the current IE browser window.

-------------------------------------------
Steps to enable Doc links to open outside of IE:
1. Launch Windows Explorer.
2. From the Tools menu, select Folder Options.
3. From the Options dialog box, click the File Types tab.
4. From the listing of "Registered File Types," select "Microsoft Word Document," and click the Advanced button.
5. From the Edit File Type screen, clear the "Browse in same window" check box, which toggles whether a Word document is launched outside of Internet Explorer.
6. Click OK to close the dialog boxes.

OR - create a registry file from the lines below and merge it in registry.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Word.Document.8]
@="Microsoft Word Document"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8]
@="Microsoft Excel Worksheet"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\PowerPoint.Show.8]
@="Microsoft PowerPoint Presentation"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Visio.Drawing.6]
@="Microsoft Visio Drawing"
"EditFlags"=dword:00010000
"BrowserFlags"=dword:00000008