I don't think you can do it in the cell. This might give you a solution but
in another cell:

=RIGHT(TEXT(A1,"dd/mm/yyyy"),1)

Regards

Trevor


"Torrance Pollard" wrote in message
...
Hey,
is there any way to format this date 2005 so that it only shows the year
number 5
thanks