Instead of using TODAY() or a reference to a cell which contains TODAY(),
you need to embed it in a TEXT function, like:
="TODAY IS "&TEXT(TODAY(),"m/d/yy")&"."
Bob Umlas
Excel MVP
"Ken G." wrote in message
...
I wish to include today's date in a concatenated statement, but it always
shows up as the date number instead of the date. How do I show the date?
|