I admit I'm confused by this. I'm using Excel '97 (Yes, yes, I know. Upgrade.
But this is a client's system over which I have no control.)

The client supplied me with a spreadsheet containing a lot of data. I need
to make the data consistent for it to be usable. There is a column containing
only the year which is currently defined as Text. I want the data to be Date
type with a "YYYY" format.

I managed to do this somehow in another spreadsheet of similar data. In the
spreadsheet I'm currently working on, when I change the column to Date type
with "YYYY" format, the value in the cell is wrong.

Example: The value in the cell should be "1994." When I change the type to
Date format "YYYY" and enter "1994" in the cell, the formula bar displays
"6/16/05" and the cell display is "1905." If I type "1995" in the cell, the
formula bar displays "6/17/05."

I wasn't even sure how to phrase this question for the KB. Any ideas? Thanks.