On Wed, 8 Mar 2006 16:59:27 -0800, Dave76Mizzou
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