See if re-formatting the cell to General solves your problem.
--
Gary''s Student - gsnu200811


"Wendy Farkas" wrote:

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.