software

I have 4 columns of data which I want to add together to make one column of
data. 3 of the columns are text and one is a date.

The formula I have used is..

=quot;text here quot;amp;C21amp;quot; more words here quot;amp;D21amp;quot;,quot;amp;quot; client ID quot;amp;E21amp;quot; went to
quot;amp;F21

so it reads text as a sentence. The problem is that quot;amp;F21 is a date, and it
displays it as a number, not a date. The formatting doesnt get carried
across.

The formatting of both columns are formated as dates.

Can anyone help to make it display as a real date in the forumla column?

thanks
amp;TEXT(F21,quot;dd mmm yyyyquot;) or another formatting string

--
Kind regards,

Niek Otten

quot;Lukequot; gt; wrote in message
...
gt;I have 4 columns of data which I want to add together to make one column of
gt; data. 3 of the columns are text and one is a date.
gt;
gt; The formula I have used is..
gt;
gt; =quot;text here quot;amp;C21amp;quot; more words here quot;amp;D21amp;quot;,quot;amp;quot; client ID quot;amp;E21amp;quot; went to
gt; quot;amp;F21
gt;
gt; so it reads text as a sentence. The problem is that quot;amp;F21 is a date, and
gt; it
gt; displays it as a number, not a date. The formatting doesnt get carried
gt; across.
gt;
gt; The formatting of both columns are formated as dates.
gt;
gt; Can anyone help to make it display as a real date in the forumla column?
gt;
gt; thanks
gt;
gt;
superb Niek ! thanks a lot mate it worked

quot;Niek Ottenquot; wrote:

gt; amp;TEXT(F21,quot;dd mmm yyyyquot;) or another formatting string
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Lukequot; gt; wrote in message
gt; ...
gt; gt;I have 4 columns of data which I want to add together to make one column of
gt; gt; data. 3 of the columns are text and one is a date.
gt; gt;
gt; gt; The formula I have used is..
gt; gt;
gt; gt; =quot;text here quot;amp;C21amp;quot; more words here quot;amp;D21amp;quot;,quot;amp;quot; client ID quot;amp;E21amp;quot; went to
gt; gt; quot;amp;F21
gt; gt;
gt; gt; so it reads text as a sentence. The problem is that quot;amp;F21 is a date, and
gt; gt; it
gt; gt; displays it as a number, not a date. The formatting doesnt get carried
gt; gt; across.
gt; gt;
gt; gt; The formatting of both columns are formated as dates.
gt; gt;
gt; gt; Can anyone help to make it display as a real date in the forumla column?
gt; gt;
gt; gt; thanks
gt; gt;
gt; gt;
gt;
gt;
gt;