Text & Date in the same Cell???

[tallpaul]

Hi, is it possible to have text & a date in the same cell?? In A! I have todays date =today(). In D1 I want the statement, "Balance at (today's date).
I have tried =concatenate("Balance at" , & A1) but it returns a numerical value for the date bit???
Cheers
Paul.

[SteveG]

Paul,

Try it this way. No concatenate formula.

="Balance at"&" "&TEXT(TODAY(),"mm/dd/yyyy")

Cheers,

Steve

[SteveG]

Paul,

To reference the date in A1 rather than using the TODAY() in my last post.

=B1&" "& TEXT(A1,"mm/dd/yyyy")


Steve

[tallpaul]

Thanks Steve, spot on, I owe you a Pint!!