Microsoft Office Excel 2003
I am trying to put in todays date along with text. How would i do this?
in box A43 i have:
=Q1&R1&S1
in Q1 i have BBS LIST FOR
in R1 i have =TODAY()
in S1 i have HOB 6PM - 12AM
so it would be as follows:
BBS LIST FOR =TODAY() HOB 6PM - 12AM
And this is how it is coming out.
BBS LIST FOR 40058 HOB 6PM - 12AM CW TRINITY
It should look like this:
BBS LIST FOR September 2, 2009 HOB 6PM - 12AM
Is there an easier way to do this so it will come out the way I want it?
Thanks in advance!
Thanks again! You Rock!