Text Fit

  • Thread starter Thread starter mmm
  • Start date Start date
M

mmm

Typed text in rows, some are ok but some have only ###### showing up.
have text wrapped and have tried autofit.
In some cases rows that have ##### have less text than others showin
up ok.

Please reply how to fix these rows
 
###### usually means that numeric data is too big for the cell. It's
possible that the contents of the cell are being interpreted as a date
and/or time and hence the displayed text is bigger than the numeric value.

For example, 12345.6789 in a cell formatted as a date would be seen as
18/10/1933 16:17:37 and, if the column is too narrow it will show as #######

Widen the column to check this out.

Regards

Trevor
 
mmm

Try formatting the cells as General rather than as Text if Trevor's
suggestions don't pan out.

Gord Dibben Excel MVP
 
mmm,
Another possibilty is that you have a negative date. If you are using the 1900 date system (the default in excel) and enter a negative number in a cell with a date format, excel will display ######. And no matter how wide you make the cell you will still get #####.

Hope this helps.

Good Luck,
Mark Graesser
(e-mail address removed)

----- mmm > wrote: -----

Typed text in rows, some are ok but some have only ###### showing up. I
have text wrapped and have tried autofit.
In some cases rows that have ##### have less text than others showing
up ok.

Please reply how to fix these rows.
 
Back
Top