I've tried playing with all the formatting, and none of it seems to affect this.
My source file has all columns that are 15 pixels wide, meaning only a single character can fit.
If I put in TEXT, it will show the text properly that spans several columns (if there is nothing in those cells to...