A date formatted field displays in cell N2 quot;2006quot;. I need the text version
of this to display exactly the same, quot;2006quot; with no date serial lurking in
the background. My formula does not work... displays the text value of the
formula itself... =TEXT(N2,quot;mmm/ddd/yyyyquot;). How can I create a Text value
of 2006? Thanks.
On Wed, 8 Mar 2006 16:59:27 -0800, Dave76Mizzou
gt; wrote:
gt;A date formatted field displays in cell N2 quot;2006quot;. I need the text version
gt;of this to display exactly the same, quot;2006quot; with no date serial lurking in
gt;the background. My formula does not work... displays the text value of the
gt;formula itself... =TEXT(N2,quot;mmm/ddd/yyyyquot;). How can I create a Text value
gt;of 2006? Thanks.
=TEXT(N2,quot;yyyyquot;)--ron
of this to display exactly the same, quot;2006quot; with no date serial lurking in
the background. My formula does not work... displays the text value of the
formula itself... =TEXT(N2,quot;mmm/ddd/yyyyquot;). How can I create a Text value
of 2006? Thanks.
On Wed, 8 Mar 2006 16:59:27 -0800, Dave76Mizzou
gt; wrote:
gt;A date formatted field displays in cell N2 quot;2006quot;. I need the text version
gt;of this to display exactly the same, quot;2006quot; with no date serial lurking in
gt;the background. My formula does not work... displays the text value of the
gt;formula itself... =TEXT(N2,quot;mmm/ddd/yyyyquot;). How can I create a Text value
gt;of 2006? Thanks.
=TEXT(N2,quot;yyyyquot;)--ron
文章標籤
全站熱搜
