I consider myself a fairly experience excel user, but I've never come across this problem before.

Whenever I format a text box to have multiple columns, the text disappears.

I'm sure there's a simple explanation, but I can't figure it out. Please help, it's driving me nuts!