I get # symbols in my cell instead of text

I have large blocks of text in some of my cells and they show up as
########## instead of the text I put there. If I click on the cell I see my
text above in the text edit box, but not on the spreadsheet.

I believe there is a maximum number of characters in a cell before ### shows
for everything.

"Betsy" wrote:

> I have large blocks of text in some of my cells and they show up as
> ########## instead of the text I put there. If I click on the cell I see my
> text above in the text edit box, but not on the spreadsheet.

"Betsy" <Betsy@discussions.microsoft.com> wrote in message
news:82D4E5E8-D5B0-47D2-912C-F59D3B6D494D@microsoft.com...
> I have large blocks of text in some of my cells and they show up as
> ########## instead of the text I put there. If I click on the cell I see
my
> text above in the text edit box, but not on the spreadsheet.

Try widening the column

I have widened it as far as possible and still no luck.

"Betsy" wrote:

> I have large blocks of text in some of my cells and they show up as
> ########## instead of the text I put there. If I click on the cell I see my
> text above in the text edit box, but not on the spreadsheet.

### sometimes occur when you create formulas that result in negative time
values, which isn't possible.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Betsy" <Betsy@discussions.microsoft.com> wrote in message
news:BA162C3C-41D3-4FFB-8CAC-F1B12B6A0714@microsoft.com...
> I have widened it as far as possible and still no luck.
>
> "Betsy" wrote:
>
> > I have large blocks of text in some of my cells and they show up as
> > ########## instead of the text I put there. If I click on the cell I
see my
> > text above in the text edit box, but not on the spreadsheet.

I seem to be only at 250 characters... what is the limit?

"Betsy" wrote:

> I have large blocks of text in some of my cells and they show up as
> ########## instead of the text I put there. If I click on the cell I see my
> text above in the text edit box, but not on the spreadsheet.

Betsy, when you click on the cell, what is the content of the formula bar?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Betsy" <Betsy@discussions.microsoft.com> wrote in message
news:50D905DE-D2D3-4372-A177-60180672D635@microsoft.com...
> I seem to be only at 250 characters... what is the limit?
>
> "Betsy" wrote:
>
> > I have large blocks of text in some of my cells and they show up as
> > ########## instead of the text I put there. If I click on the cell I
see my
> > text above in the text edit box, but not on the spreadsheet.

If it's text, try changing the format of that cell to General.

Long text (255 characters to 1024 characters) in cells formatted as Text will
show as ####'s.



Betsy wrote:
>
> I have large blocks of text in some of my cells and they show up as
> ########## instead of the text I put there. If I click on the cell I see my
> text above in the text edit box, but not on the spreadsheet.

--

Dave Peterson