Excel cell: date number error

Symptom:
After giving different data series (from non-Excel format), certain cells in the given columns take a date value. Set to number format is giving back not the original number in that cell.

Solution:
Windows regional settings must be changed to English (United States) format.
Control Panel => Clock & Area => Region => Format

Microsoft Patch Tuesday – March 2018 - Word 2016 crashes due to Endnote plugin

Symptom: After Microsoft Patch Tuesday – March 2018,  Word 2016 crashes due to Endnote plugin and only starts in safe mode.

Solution: Until fix this error, disable Endnote plugin.

How to competely remove pre-installed Office 365 (activation panel remained problem)

Symptom:
After removing a pre-installed Office 365, and install another version of Office (eg. Office 2016)  the activation panel of Office 365 remains.

Solution
Use Microsoft Fix it tool to remove the pre-installed Office 365
Download link: http://go.microsoft.com/?linkid=9815935

Source: Microsoft

Is my Microsoft Office 32-bit or 64-bit version?

How to find if your Microsoft Office is 32-bit or 64-bit version?
How do I know if my Office is 32-bit or 64-bit?

Open an Office app e.g. Word.
Click on "File", than “Account” and “About Word”
See the first row.

Powerpoint 2010 crashes when you play embedded video files

Problem:
Powerpoint 2010 crash when you play embedded video files

Solution:
Save file as 97-2003 .ppt format
(Of course in this case special .pptx effects, etc. lost.)

Source: Microsoft

Microsoft Outlook 2013 error message "Cannot open the Outlook window. The set of folders cannot be opened. The information store could not be opened"

Check Outlook compatibility mode:
Open: C/Program Files/Microsoft Office/Office 15/Outlook.exe.
64 bit system: C:/Program Files x86/Microsoft Office/Office 15/Outlook.exe.
Right click on Outlook.exe and click on Properties and then click on Compatibility tab.
Check if you have any check mark in any of the compatibility mode options.
Make sure you also click on the option "change settings for all users" tab at the bottom of the same screen and look for similar check boxes in the window.
If you see any check boxes in the compatibility mode options, uncheck all the boxes.
Apply
OK.
Try to open Outlook and check the result.

Source and other solutions: answers.microsoft.com

Choose the 32-bit or 64-bit version of Office

The 32-bit version of Office 2010 is the recommended option for most people, because it prevents potential compatibility issues with other 32-bit applications, specifically third-party add-ins that are available only for 32-bit operating systems.

Applies to:  Office 2010 | Office 2013 | Office 365 ProPlus

Source:
office.microsoft.com
technet.microsoft.com

Continue Setup program is interrupted after installation: Microsoft Office 2007 / 2010

The 2007 Office suite or the 2010 Office suite Setup program will not restart after an initial installation is interrupted:

http://support.microsoft.com/kb/927153/en-us