Use TEXT to format the date to taste, eg:
="The date is: "&TEXT(B2,"dd-mmm-yyyy")

Likewise for formatting numbers to a certain x dp
=TEXT(A1,"0.00")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Gunti" wrote:
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?