Excel has a problem with text when the number of characters in a cell is between
255 and 1024.

Format to General to get rid of the ###### marks.

Also, wrap text works on merged cells but Autofit does not.


Gord Dibben MS Excel MVP

On Thu, 3 Apr 2008 14:37:00 -0700, John Kotuby
wrote:

Hi all,

I am working with a 3rd party Excel file generator that is a very well
established product for Web development. However, I myself know little about
formatting Excel.

Here is the problem. One of my Cells which is formatted as Text, Wrap and
Merge (across 5 cells), seems to work fine on some text and on others just
displays hash marks across the cell. Usually this means the contents are to
large for the cell.

However, the cells (and they are all formatted the same) that display
correctly have 6 to 7 rows of wrapped text. When I hover my cursor over the
cells with the hash marks it looks like there is actuall LESS text displayed
than in the cells that look correct.

I see there is a checkbox for "Shrink to Fit". I see no "Expand to Fit" as I
think this might be a default when Wrap is selected.

Can anyone explain what might be happening?

Thanks...