="for week " & actuals!x99 & " ending"

You could even do:

="Please pay me by: " & text(a1,"mm/dd/yyyy")

to get the formatting the way you want.

Weasel wrote:

In cell F2 of a sheet named "main flash" I want to have it display the
following:

"for week 42 ending"

The week 42 part would come from another sheet named "actuals" that's
in the same workbook.

--
Weasel
------------------------------------------------------------------------
Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=525683

--

Dave Peterson