ExcelBanter - Convert a Date to Text?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert a Date to Text? (https://www.excelbanter.com/excel-worksheet-functions/76120-convert-date-text.html)

Dave76Mizzou

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.

Ron Rosenfeld

Convert a Date to Text?

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

All times are GMT +1. The time now is 11:21 AM.