Concatenate

[Matt]

I'm having problems concatenating a text formatted cell with a date formatted cell. Each time that I try to concatenate the 2n cells the date reverts back to the code e.g. 37305 rather than retaining the date format 19/01/02. Does anyone have any ideas to get around this.

Thanks

Matt

 

[Aladin Akyurek]

Matt,

Try:

=A1&" "&TEXT(B1,"dd/mm/yy")

where A1 houses a text value and B1 a date.

Aladin

 

[Guest]

If your text is in A1 and your date in A2 :-

=A1 & TEXT(A2,"d/mm/yy")

 

[Matt]

That's worked a treat, Thanks alot

Matt

 

[Guest]

On 2002-02-18 03:27, Aladin Akyurek wrote:
Matt,

Try:

=A1&" "&TEXT(B1,"dd/mm/yy")

where A1 houses a text value and B1 a date.

Aladin

Adding a space to the concatenation is not necessary.
Instead, the formula could entered as :-
=A1&TEXT(B1," dd/mm/yy")