Microsoft Excel Question:
Download Questions PDF

Where can I find some really good information on how excel treats year 2000 dates? I need simple (and that is what u guys provide)?

Answer:

Any 2 digit dates since January of 1930 will be assumed to be 1930 or after. Microsoft converts an entry of 1/1/30 to be 1/1/1930. (It does the conversion in memory - it may not show it in the spreadsheet)
Any 2 digit dates lower than 12/31/29 are assumed to be 2029 or before.
You can avoid the problem altogether by entering the dates with 4 years. Enter 5/27/1922 to enter a date in 1922, or 5/27/2034 for a date in year 2034

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?Ihave been working with downloaded data and pasting a years worth at a time into a "template" that I want all the resulting spreadsheets to look like. Each years data has approximately the same amount of data in it. Seems each spreadsheet is taking more and more space as I work on them? Any ideas what I have done?