27. How can I reduce the year 2000 risk for my Excel spreadsheets?
The use of dates in Excel is very common, and two-digit date shortcuts to represent calendar years introduce risk to personal files created with Excel. You can greatly reduce potential year 2000 issues by consistently using four-digit dates on all of the spreadsheets you create. This is particularly true if you plan to exchange or share spreadsheet data with others.
You can change the way spreadsheets are formatted in Excel by changing the Date formats in the Windows Regional Settings to use 4 digits for years. To do this, make sure that both the selected formats for the Short Date and the Long Date have four digits ("YYYY") for the year.
Additional Terms of Use |
