|You will need a Custom Format|
On the Task Bar,
Select Custom (Bottom of List)
On the right side, Under the word "Type"
delete the word "General"
and add YYYY
Your cell will now show only the Year.
Also, you will get a better response to Excel questions if you post your questions in the Office Software forum.