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" wrote in message
...
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