Using Ampersand & Date Function

[RsuROPf]

How to avoid getting a serial number format if I need to join a date with Ampersand.
For example in on column I had a date and the other column I had a text and I want to join the date and text using ampersand.
I want my cell to have something like : 12/13/13 - WEEK 2

Thanks.

 

[shyy]

Welcome to the board!

the format like this?

Excel 2010

	A	B
12/13/13 - WEEK 2

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]41621[/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B1[/TH]
[TD="align: left"]=TEXT(A1,"mm/dd/yy")&" - WEEK 2"[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Wagner Morel]

RsuROPf,





Assuming that the date is in cell A3 and the text is in cell B3, enter this formula in cell C3:

=MÊS(A3) & "/" & DIA(A3) & "/" & ANO(A3) & " - " & B3

 

[RsuROPf]

Great!!!

Thanks Everyone. I appreciate the feedback received below!!.