Text & Date in the same Cell???

T

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.
 
S

SteveG

Paul,

Try it this way. No concatenate formula.

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

Cheers,

Steve
 
S

SteveG

Paul,

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

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


Steve
 
Top