Years Conversion in Numbers
Posted: Fri Jan 28, 2011 2:09 pm
I am trying hard to make an attempt to switch over to Numbers for my various spreadsheet data bases, and am having some success. But one thing has come up I'd like to correct. When I copy and paste a listing of dates, such as "July 21, 1919" from Appleworks spreadsheet into a Numbers spreadsheet, it turns all my years preceding with "19" in a "20". So each of the 65 dates in my original list (birth years for deceased baseball players) displays a date exactly 100 years off. How can I fix this without going through each cell and repairing the data manually?