Convert a Date to Text?

A date formatted field displays in cell N2 "2006". I need the text version
of this to display exactly the same, "2006" with no date serial lurking in
the background. My formula does not work... displays the text value of the
formula itself... =TEXT(N2,"mmm/ddd/yyyy"). How can I create a Text value
of 2006? Thanks.

On Wed, 8 Mar 2006 16:59:27 -0800, Dave76Mizzou
<[email protected]> wrote:

>A date formatted field displays in cell N2 "2006". I need the text version
>of this to display exactly the same, "2006" with no date serial lurking in
>the background. My formula does not work... displays the text value of the
>formula itself... =TEXT(N2,"mmm/ddd/yyyy"). How can I create a Text value
>of 2006? Thanks.

=TEXT(N2,"yyyy")


--ron