Try something like:
="Date is: "&TEXT(TODAY(),"dd mmm yyyy")
Try also Debra's coverage on combining data at her:
http://www.contextures.com/xlCombine01.html
See especially the formatting examples towards the bottom of the page
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"A. Toczko" wrote in message
...
I was wondering if there is a way to mix text and a formula in a cell.
I'd
like to embed today's date (using the function =TODAY()) in the middle of
a
sentence. Thanks.