What's in cell A1? Is it a date?

If you used my variation of the formula, make sure you include all the
double quote marks:

=TEXT(A1+7,"dd-mmm-yyyy") & CHAR(10) & " this is some event text"

blueboy wrote:
I just copied and pasted the text in your message, but it didn't work. Yes,
it is English.

"Dave Peterson" wrote:


What was the formula you used?

Do you use an English version of excel?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html