="The contractor will provide insurance by " & TEXT(A8,"m/d/yyyy") & " and
Hope this helps,
"Brushie76" <Brushie76@discussions.microsoft.com> wrote in message
>I am trying to display the date as 1/21/05 in a cell that contains a
> with the date nested between text... i.e.
> ="The contractor will provide insurance by "&(Cell A8)&" and start
> I have a front page where I input all my project criteria including dates
> and then I have documents that have similar verbage as above and have
> within in them... I currently stop my text right before the cell where
> date will be displayed and then start the text after the date cell... I
> like doing it this way.