Convert a Date to Text?

D

Dave76Mizzou

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.
 
R

Ron Rosenfeld

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.
Click to expand...

=TEXT(N2,"yyyy")


--ron
 
Top