2 digit years being converted incorrectly

G

Guest

This is a follow-up question. I have a large spreadsheet that was orginally
an Excel 2.1 file. There are about 6,000 dates that needed to be changed
from 2 to 4 digit years. That problem has been addressed. New problem. I
have changed the global setting in Windows so that 2 digit dates are
interpreted as being betwee 1908 and 2007, so 01/01/22 should be January 1,
1922 NOT January 1, 2022 as is the default. If I put a new date into the
spreadsheet it works correctly, but the dates in the spreadsheet are
interpreted according to the default rule . . . any ideas?
 
G

Guest

One thing you could try is Find/Replace

Find = /
Replace = /

but be sure to back up your data in case the results are not what you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change a list of 2 digit years to 4 digit years? 5
changing dates and years with less keystrokes 13
Recognizing 2-digit years 12
Totals based on dates 1
XIRR Function - #NUM error 4
2 digit year in dates return 19xx not 20xx 1
y2k problem 8
Date format: how does Excel choose which century for 2-digit entries? 3

Top