Same bug/feature existed in earlier versions when char count was 255 to 1024
and Text formatted.


Gord Dibben MS Excel MVP

On Thu, 17 Dec 2009 13:25:01 -0800, Eric_NY
wrote:

It looks fine after changing to General format.

I believe it was OK in Excel 2003, but I no longer have access to Excel 2003
to see.

Thanks.


"Dave Peterson" wrote:

I would have guessed that the problem also appears in xl2003 (you may want to
check again).

But try formatting the cell as General (or anything but Text).

Excel has trouble strings between 256 and 1024 characters in cells formatted as
Text.

Eric_NY wrote:

In Excel 2007, I've opened a file I created in Excel 2003.

It looked fine in Excel 2003. But now, in Excel 2007, one cell now appears
as #############, onscreen and in Print Preview and when printed. The cell
contents look fine in the the entry line at the top of the screen, or when I
put the cursor in the cell and hit F2 (edit). The cell contains multiple
lines of text. I've tried it both with Wordwrap and without, but the cell
still appears as ################.

Any suggestions on how to get hese cells to display normally again?

Thanks.

--

Dave Peterson
.