TEXT function does not change date format

Hello,

I'm using the CONCATENATE function to put together a sentence mixing text and date. The formula I'm using is:

=CONCATENATE("Text part here "; TEXT(B1;"d.m.yyyy"))

I have the date in cell B1 obviously, as "1.6.2011". What I want the formula to produce is "Text part here 1.6.2011". I've tried with different date formats, but I only get "Text part here d.0.yyyy".

I also tried putting the true value of the date in the formula (=CONCATENATE("Text part here "; TEXT(40695;"d.m.yyyy"))) but it doesn't change the format then either.

Any help is greatly appreciated.

Regards,
Pauliina