Can't Enter Years in a Cell
Sometimes getting the right thing to show up in a cell can be a bit tricky when working with dates. If you enter a year number and Excel does some funky interpretation of what you entered, this tip explains what is happening.
Read this tip »
(Thanks to Mohammad Al Khalidy, Martyn Passmore, Andrija Vrcan, Martin Nicol, Steve Aprahamian, Danijel Namjesnik, Daryl Braun, David Prout, Jim Shearouse, Susan Jorgensen, Nora Abbott, Guy Goodwin, Steve Lindquist, Fletch Brownlee, Mark Groessl, Barb Lange, Erik Oberg, Paul Sprunken, Dave Onorato, John Louws, John Vander Linden, Jacques Raubenheimer, Mike Hodkinson, Simon Paterson, Bob Beechey, Jonathan Clipston, Mike Shellito, Bob Hall, Tom Mullan, Henry Arthur, Dave Kerr, Tom Van Dam, Brent Montague, Monica Birren, Damian Fennelly, Colin Delane, Peter Aitken, Mark Marikos, Arturo Lopez, Gonzalo Pereyra, Teri Buchanan, Scott Renz, Aldo Santolla, Erik Ersser, David Gray, Peter Shepherd, and Bud Beaty for contributing to this tip.)