format/concatenation

[alm09]

I have a concatenation in cell C1 based on cells A1 and B1 as follows:

A B C
405 1/31/06 Concatentate(A1,&"-",&B1)


Cell C1 subsequently reads 405-38748. I have been changing formats in cell
B1 with no luck. I need cell C1 to read 405-1/31/06. What am I missing?

 

[Elkar]

Try this:

=A1&TEXT(B1,"-m/d/yy")

HTH,
Elkar