In a cell formatted for text, the contents display as #####, whether wrap is
selected or not in the Format options. Widening the column doesn't solve the
problem, as with numerals in number-formatted cells.