Wrap Custom Number Formats?

I would suggest to use formula. That way you can apply Wrap Text.

=TEXT(A2,"mmm dd ")&"Basic Member Contribution"

Row\Col	A
1	Jul 15 Basic Member Contribution
2	7/15/2015

Then you can hide row 2 and leave the first row.

I thought of that, but I have other information below the headers, and also that then gives me a text value instead of a number, and then I can't use a formula like 'A1+1' in column B, & 'B1+1' in column C, and so on.

That's sort of my 'last resort' option

Originally Posted by Tamarissa

I thought of that, but I have other information below the headers, and also that then gives me a text value instead of a number, and then I can't use a formula like 'A1+1' in column B, & 'B1+1' in column C, and so on.

That's sort of my 'last resort' option

Even if you hide the second row you can still reference it in your formulas so there is no loss in functionality.

I didn't think it would work but it does

custom mmmm dd "Basic Member ALT+010Contribution"
Make sure the cell is formatted with Wrap text
See attached

Hmmm, it works but it doesn't work. The string (actually number) wraps but the column still needs to be wide enough to handle entire string so it defeats the purpose. Weird.

I think your best bet is something like AlKey mentioned. Put the date in row 2, then in row 1
=Text(A2,"mmmm dd")&"Basic Member Contribution" with wrap text. Then Hide row 2
Then row 3
=A2+1