How to output a date as text string in a specified format?

[FreeMinded]

I’m trying to concatenate text with dates.
I found this question which Calc: how to copy a date format in a text string helps me half the way. Using the function TEXT I can covert a date to a text string. But it only seems to work with yyyy-mm-dd as format. How can I get a text string in the dd.mm.yyyy format?

[mark_t]

Function would be changed to :

=TEXT(B6,"dd.mm.yyyy")

[hannu]

should be possible, but do not work

[titus]

works for me, except for minor change (replace comma by semicolon) :

=TEXT(B6;"dd.mm.yyyy")

The format code can be determined in the menu Format → Cells …