Year Date Conversion To Text

[ComradeBT]

Hello,

What's the easiest way to convert a date currently set in dd/mm/yyyy format to a text/string format that just takes the yyyy part? i.e. I wish to convert 01/01/2010 and only obtain '2010' as a text string.

Thanks.

[NBVC]

Try

=Text(A1,"YYYY")

[davesexcel]

try
=YEAR(A1)