Forum Discussion
Need help regarding DATE FORMAT
In the dialog box for formatting numbers you can selec, down at the bottom of this dialog box, the selection for "More Number Formats"
And then pick the format that shows a year in 4 digits, and apply that to all the birthdates.
What you'll discover, I think---is that basically any birthdates in the early part of the last century (from 1913 up through 1929) were increased by a century. In fact, I see no birthdates between 1995 and 2013 on your sheet (because I'd already opened it, it still is on my computer--I'll delete it after we're done and promise I won't use anything fro it)...
My guess is that any birthdates between 1901 and 1929 would be there as 2001 on. For what it's worth your sheet does show one person as born in 2013 (my father's birth year as it happens.) So that's either a person who's only 7 or a person who is 107! Given your knowledge of what this list is about, is the former possible? The latter is unlikely, but possible. And it does show that person as enrolled in Medicare (which I think precludes a seven year old)
ANyway, I sorted the database in order by Date of Birth, which is how I was able to see the full sequence IN order..... Once you've done that it should be relatively easy to use a formula to correct for those needing it.
I would want to know more about the process you're going through. You say you're "not importing" so maybe you understand that word differently than I do. My usage was just to mean "importing a csv file into Excel" -- i.e., it begins as something outside the Excel universe and is brought in. What I didn't understand from you is why you refer to copying the cells over.... because when you "import" (my definition) a csv file into Excel, you can then just do a "Save As...." and convert it to Excel. There's no "copy" step in that sequence.
None of this directly addresses your date quandary. My guess regarding that is there may be a default setting under "Excel".... "Preferences" for how to deal with dates, whether or not to convert them to the current century.
Thank you. I figured out how to preserve the year in full format and it seems to be sticking to the correct century. I want to thank you for your help. Please confirm that you have deleted the files.
I have deleted the files. Deleted them from my Downloads folder, followed by deleting them from the "Trash" folder, the latter being a deletion that can't be undone.
I'm going to be sending you a message privately as well. You'll see a red notification number (number 1, unless you've gotten the same from other people) up on the right side of the bar at the top of this screen.