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
1	41621	12/13/13 - WEEK 2

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula B1 =TEXT(A1,"mm/dd/yy")&" - WEEK 2" <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[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!!.