View Single Post
  #2   Report Post  
Bob Umlas
 
Posts: n/a
Default

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?