CONCATENATE TEXT & FORMULAS

[LANIP]

I'm trying to concatenate a cell with text and a cell that contains a formula. The concatenate cell is working, however, the cell with a formula is in date format (mm/dd/yy), but when it is added to the text it shows as a numerical date (ex: 01/14/02 = 37270). How do I get the date to show in the destination cell in the mm/dd/yy format? I need destination cell to look like this : Week of 01/14/02 not Week of 37270.

 

[Mark W.]

On 2002-02-26 12:49, LANIP wrote:
I'm trying to concatenate a cell with text and a cell that contains a formula. The concatenate cell is working, however, the cell with a formula is in date format (mm/dd/yy), but when it is added to the text it shows as a numerical date (ex: 01/14/02 = 37270). How do I get the date to show in the destination cell in the mm/dd/yy format? I need destination cell to look like this : Week of 01/14/02 not Week of 37270.

=A1&TEXT(B1," mm/dd/yy") where A1 contains your text and B1 contains your date value.

 

[IML]

try
="week of "&TEXT(A1,"mm/dd/yy")

good luck

On 2002-02-26 12:49, LANIP wrote:
I'm trying to concatenate a cell with text and a cell that contains a formula. The concatenate cell is working, however, the cell with a formula is in date format (mm/dd/yy), but when it is added to the text it shows as a numerical date (ex: 01/14/02 = 37270). How do I get the date to show in the destination cell in the mm/dd/yy format? I need destination cell to look like this : Week of 01/14/02 not Week of 37270.