If Dec' 07 is stored as text

=right(A1,2)

if it is being stored as a date

=Text(year(A1),"00")

--
Regards,
Tom Ogilvy


"Divy" wrote:

..

hi Techies :-)

One small solution required here...

I have entered "Dec' 07" in a cell.

And i only require to display 07 in another cell.

Please suggest some formula for the same.

Cheers!!!
Divy