Using a Single Digit for a Year
Excel works very well with dates and times. One thing you cannot do, however, is to create a custom format that displays a single digit for a year. This tip looks at a couple of ways you can get around this limitation.
Read this tip »
(Thanks to Michael Avidan (MVP), Harold Druss, Ryszard Raciborski, Steve Aprahamian, Stephen Argent, Henk Haringsma, Ron Solecki, Howe Shou, David Gray, Robert Williams, Patrick Sedgwick, Tomek Dluzniewski, Wayne Edmondson, Corrie Buitendag, Fred van der Meulen, David Teece, Norman Harker, James Hoyt, and Mike Dawson for contributing to this tip.)