Posts Tagged ‘Excel 2007’

How to change the default file type for Word 2007 and Excel 2007

This item was filled under [ MS Office Tricks ]

You might already be aware that Microsoft Office 2007 applications like Word 2007 & Excel 2007 use a different file format than the earlier versions. While the earlier versions of Word and Excel used the file extension .doc and .xls respectively, Office 2007 uses the .docx and .xlsx file extension.
However, both Word 2007 & Excel [...]

Continue reading...

Excel 2007 - The 65535 & 65536 problem

This item was filled under [ MS Office Tricks, Tech News ]

If you are using Excel 2007 at office or at home, you might be surprised to know that while it can do complex calculations accurately, Excel 2007 has trouble doing simple multiplication.
While it is hard to believe, Excel makes mistakes multiplying 77.1 by 850, 10.2 by 6,425 and 20.4 by 3,212.5. Basically Excel 2007 has [...]

Continue reading...