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
|