Jim

Text being too long will not give you ## signs on a narrow column.

Numbers will give you ## signs if the column is not wide enough.

Dave is right.......Excel has a problem with text-formatted cells when the
character count is between 255 and 1024.

Changing to General format will get rid of the ## signs.


Gord Dibben MS Excel MVP

On Tue, 15 Jul 2008 20:38:45 -0700, Jim Thomlinson
wrote:

The text is too wide to display. Expand the column size or allow the cell to
wrap text.