Hi Charlene

not really sure what you're after here
if you have
1/1/05
and you want to display just
2005
then right mouse click on the cell and choose format cells / on the numbers
tab, choose custom and then type
yyyy
in the white line and and click OK.

however, this just displays the date showing only the year, if you want to
extract the year only to another cell you can use
=year(A1)
where A1 contains the date

if you're after something else, please type a few examples of the data you
have and what you want to see.

Cheers
JulieD

"Charlene" wrote in message
...
How can I make a cell correct the year of a date