F
Fred Smith
I have a column of maturity dates which I converted to Excel dates using
DATEVALUE. The dates all had two digit years. DATEVALUE converted years
prior to 30 in the 21st century, and years greater than 30 in the 19th. But
I want them all in the 21st century. Some years go up to 51.
I figured my regional settings were the culprit, so I changed the two-digit
year option from 2030 to 2055. No success. So I closed Excel, rebooted,
loaded the file again, but still no success
Any ideas where I look next?
DATEVALUE. The dates all had two digit years. DATEVALUE converted years
prior to 30 in the 21st century, and years greater than 30 in the 19th. But
I want them all in the 21st century. Some years go up to 51.
I figured my regional settings were the culprit, so I changed the two-digit
year option from 2030 to 2055. No success. So I closed Excel, rebooted,
loaded the file again, but still no success
Any ideas where I look next?