Sometimes, the YEAR function returns the correct value, but Excel displays an unexpected year, such as 1900 or 1905. This occurs when the cell containing the YEAR formula is formatted as a Date ...
How-To Geek on MSN
I ditched manual cell formatting and saved hours of Excel work
Build a consistent visual system in Excel using cell styles, including customization, global updates, and workbook-wide reuse.
If Format Painter is not working in Word, Excel, and PowerPoint, verify the keyboard shortcut, disable all add-ins, reset app ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results