Text Fit

[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

 

[Trevor Shuttleworth]

###### 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

 

[Gord Dibben]

mmm

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

Gord Dibben Excel MVP

 

[Mark Graesser]

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.