Right-click on the cell and select Format Cells. Click on the Number tab and
select Custom at the bottom of the list. Clear the Type: text box and enter
yyyy. Click OK.

"Torrance Pollard" wrote:

Hey,
is there any way to format this date 2005 so that it only shows the year
number 5
thanks