Excel Tip.com has been developed to help both professionals and students to learn and develop their MS-excel skills. We at Excel Tip assist you in creating interactive spreadsheets for making calculations, performing reconciliations and maintaining employee reports, creating "pivot tables" for data management, auto-filter to sort records, V and H-Lookups for data sorting and much more... At Excel Tip, we make it our aim to make you excel in Microsoft Excel by providing you with the help of the best- in- the- field experts... Excel makes many assumptions in the background as an attempt to improve the user's productivity. These assumptions often take statistical probabilities into account. The assumption engine arbitrarily, but based on probability, assumes that dates prior to 1930 are unlikely. The only workaround I am aware of is to type the full four digits of the year in question. Incidentally, if you type only the month and day (Jan-01, for example) excel assumes that the date is..
Also known as: Excel Tip.com