Hi,

Try this with a date in C1

=" Hi my name is "& TEXT(C1,"DD-MM-YYYY") &" and this is my question"

Mike

"Gunti" wrote:

Hi,
I'm aware i can refer pieces of text through:

C1 = Gunti
=" Hi my name is "& C1 &" and this is my question"

I've got a question, i've often enough had the trouble of putting a date in
there. It somehow doesn't get the date format though - it puts the excel date
value in there. It also happens that it doesn't round the number to an amount
i want it to.

How can i format these type of cells?

Greets,
Gunti