Recognizing 2-digit years
Today I found to my consternation that my broker's updated web pages
have changed the format of the CSV files I download daily. I have
to re-work some complex formulas. On my way to accomplishing that,
I find one change is that what had been four-digit years are now
two-digit years. My Excel 2002 under XP isn't recognizing them as
dates. Is there an easy fix here?
Thanks,
Dallman
|