From Excel Help:

If you are using Microsoft Windows 2000 or later, the Regional Options in Windows Control Panel controls how Excel interprets
two-digit years.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dallman Ross" <dman@localhost. wrote in message ...
|
| 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