change a list of 2 digit years to 4 digit years?
That didn't do it, it just reduced the date to a set of 6 numbers, 29-Oct-06
turns into 102906. I should maybe add that Excel sees all of these dates
errors. Each cell has a little green triangle in the upper left corner,
mousing over the cell brings up a little notification icon with a drop down
menu that gives several options for fix fixing or ignoring the error. I can
change a block of cells all at once this way, but the dates are mixed, so is
takes a while to select them all.
"Duke Carey" wrote:
Select a single, empty cell
Edit-Copy
Select all the dates
Edit-Paste Special-Add-Values
Should take care of it
"Fredgus" wrote:
I need to convert a list of dates that is formatted with 2 digit years, 89
for 1989 or 02 for 2002, to 4 digit years. The list has about 6,000 dates,
so I REALLY don't want to fix it one at a time. Excel seems to know what to
do, it I simply double click the date and then move off it (by click or enter
key) the date is adjusted to 4 years accroding the microsoft formula (which
works for ALL the dates in the list). How do I have excel do all the dates
at once?
|