software

Hello and thanks for the help.

I am bringing together two cells one with the date and then a dash, the next
cell has my note. I cannot seem to figure out how to keep the date format.
Any help?Friday, February 10, 2006
My note goes here=c2amp;quot; - quot;amp;C338758 - My note goes here
Use the text function to tell Excel how to format the number in C2 (dates are
really just numbers formatted in a certain way).
=text(c2,quot;dddd, mmmm dd, yyyyquot;) amp; quot; - quot; amp; c3
--Bruce

quot;JRquot; wrote:

gt; Hello and thanks for the help.
gt;
gt; I am bringing together two cells one with the date and then a dash, the next
gt; cell has my note. I cannot seem to figure out how to keep the date format.
gt; Any help?
gt;
gt;
gt; Friday, February 10, 2006
gt; My note goes here
gt;
gt;
gt; =c2amp;quot; - quot;amp;C3
gt;
gt;
gt; 38758 - My note goes here
gt;
gt;

This is great - thanks

Can you also tell me how I would go about making the date bold?

Thanks again

quot;bpeltzerquot; wrote:

gt; Use the text function to tell Excel how to format the number in C2 (dates are
gt; really just numbers formatted in a certain way).
gt; =text(c2,quot;dddd, mmmm dd, yyyyquot;) amp; quot; - quot; amp; c3
gt; --Bruce
gt;
gt; quot;JRquot; wrote:
gt;
gt; gt; Hello and thanks for the help.
gt; gt;
gt; gt; I am bringing together two cells one with the date and then a dash, the next
gt; gt; cell has my note. I cannot seem to figure out how to keep the date format.
gt; gt; Any help?
gt; gt;
gt; gt;
gt; gt; Friday, February 10, 2006
gt; gt; My note goes here
gt; gt;
gt; gt;
gt; gt; =c2amp;quot; - quot;amp;C3
gt; gt;
gt; gt;
gt; gt; 38758 - My note goes here
gt; gt;
gt; gt;

You can't do that through a formula, but you could through format.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;JRquot; gt; wrote in message
news
gt; This is great - thanks
gt;
gt; Can you also tell me how I would go about making the date bold?
gt;
gt; Thanks again
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; Use the text function to tell Excel how to format the number in C2
(dates are
gt; gt; really just numbers formatted in a certain way).
gt; gt; =text(c2,quot;dddd, mmmm dd, yyyyquot;) amp; quot; - quot; amp; c3
gt; gt; --Bruce
gt; gt;
gt; gt; quot;JRquot; wrote:
gt; gt;
gt; gt; gt; Hello and thanks for the help.
gt; gt; gt;
gt; gt; gt; I am bringing together two cells one with the date and then a dash,
the next
gt; gt; gt; cell has my note. I cannot seem to figure out how to keep the date
format.
gt; gt; gt; Any help?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Friday, February 10, 2006
gt; gt; gt; My note goes here
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; =c2amp;quot; - quot;amp;C3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; 38758 - My note goes here
gt; gt; gt;
gt; gt; gt;