y2k problem
From your own post:
<you are using Microsoft Windows 2000 or later, the Regional Options in Windows Control Panel controls how Excel interprets
two-digit years.
What is your question?
Or did I miss anything?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"kshelton" wrote in message ...
| So I'm importing a file from a query and many of the dates are coming up
| incorrectly. Some years are showing up as 2018 instead of 1918, 2024
| instead of 1924. I think you get the picture. I found the below on MS Excel
| Help, but I would like to know if there is any way to work around it or
| change the setting. Thanks in advance for any assistance!
|
| How Excel interprets two-digit years
|
| To ensure that year values are interpreted as you intended, type year values
| as four digits (2001, rather than 01). By entering four digits for the years,
| Excel won't interpret the century for you.
|
| For Microsoft Windows 2000 or later
|
| If you are using Microsoft Windows 2000 or later, the Regional Options in
| Windows Control Panel controls how Excel interprets two-digit years.
|
| For dates entered as text values
|
| When you enter a date as a text value, Excel interprets the year as follows:
|
| 00 through 29 Excel interprets the two-digit year values 00 through 29 as
| the years 2000 through 2029. For example, if you type the date 5/28/19, Excel
| assumes the date is May 28, 2019.
| 30 through 99 Excel interprets the two-digit year values 30 through 99 as
| the years 1930 through 1999. For example, if you type the date 5/28/98, Excel
| assumes the date is May 28, 1998.
|