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


=c2&" - "&C3


38758 - 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,"dddd, mmmm dd, yyyy") & " - " & c3
--Bruce

"JR" wrote:

> 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
>
>
> =c2&" - "&C3
>
>
> 38758 - My note goes here
>
>

This is great - thanks

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

Thanks again

"bpeltzer" wrote:

> 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,"dddd, mmmm dd, yyyy") & " - " & c3
> --Bruce
>
> "JR" wrote:
>
> > 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
> >
> >
> > =c2&" - "&C3
> >
> >
> > 38758 - My note goes here
> >
> >

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)

"JR" <(E-Mail Removed)> wrote in message
newsE6B9FFB-DC45-4607-A90E-(E-Mail Removed)...
> This is great - thanks
>
> Can you also tell me how I would go about making the date bold?
>
> Thanks again
>
> "bpeltzer" wrote:
>
> > 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,"dddd, mmmm dd, yyyy") & " - " & c3
> > --Bruce
> >
> > "JR" wrote:
> >
> > > 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
> > >
> > >
> > > =c2&" - "&C3
> > >
> > >
> > > 38758 - My note goes here
> > >
> > >