How do I include TEXT in the same cell with a FORMULA?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a cell containing the formula "=TODAY()" . This formula returns and
displays the current date in the cell. I want to ADD the TEXT "Today's Date"
to the SAME CELL without interfering with the functioning of the formula. Is
it possible to do this in Excel? If so, what is the procedure? THANKS in
advance to anyone who knows the answer and can post it here!
 
Format the cell (Format - Cells - Number - Custom, Type box):

"Today's Date" m/d/yyyy

Change the date formatting to suit.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top