Text & Date in the same Cell???
 

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.


--
tallpaul
------------------------------------------------------------------------
tallpaul's Profile: http://www.excelforum.com/member.php...fo&userid=8453
View this thread: http://www.excelforum.com/showthread...hreadid=518014

Text & Date in the same Cell???
 

Paul,

Try it this way. No concatenate formula.

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

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=518014

Text & Date in the same Cell???
 

Paul,

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

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


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=518014

Text & Date in the same Cell???
 

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


--
tallpaul
------------------------------------------------------------------------
tallpaul's Profile: http://www.excelforum.com/member.php...fo&userid=8453
View this thread: http://www.excelforum.com/showthread...hreadid=518014