With a date in A1, try this:

="Today's date is " & TEXT(A1,"mmmm d, yyyy")

The format string at the end of the TEXT function can be varied to
suit your requirements, eg "dd/mm/yy" or "mm/dd/yyyy" or "mmm dd,
yyyy" etc.

You can use TEXT for numbers as well:

="You've scored " & TEXT(A2,"0.00") & " points"

will take a numeric value in A2 and display it with 2 decimal places.

Hope this helps.

Pete

On Jan 26, 1:23*pm, 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