formatting date

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

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" <[email protected]> wrote in message
news:[email protected]...
> Hey,
> is there any way to format this date 2005 so that it only shows the year
> number 5
> thanks
>
>

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
>
>
>