On 2002-11-03 10:15, Eddie G. wrote:
Is there any way to concatenate a date and text:
cell a1 is a date 03/11/02
cell a2 is text 96% - Good
cell a3 is a comma ,
i want to concatenate all three:
03/11/02, 96% - Good
but the date comes out as a number 35755 or similar.
On 2002-11-03 14:29, lasw10 wrote:
On 2002-11-03 10:15, Eddie G. wrote:
Is there any way to concatenate a date and text:
cell a1 is a date 03/11/02
cell a2 is text 96% - Good
cell a3 is a comma ,
i want to concatenate all three:
03/11/02, 96% - Good
but the date comes out as a number 35755 or similar.
Dan just to be pedantic I think it should be:
=text(a1,"dd/mm/yy") & A3 & " " & A2