I get # symbols in my cell instead of text

B

Betsy

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.
 
B

Barb R.

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

Gordon

Betsy said:
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.
Click to expand...

Try widening the column
 
D

Dave Peterson

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.
 
S

Shia

Thank you Dave
Dave Peterson said:
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.
Click to expand...
 
C

ClaudiaV

Thanks, Dave. That was the exact answer I needed for a block of merged cells
that was limiting my entry and displaying only ####.
 
W

Wayne

Just hit this - the free microsoft works spreadsheet doesnt have this limit,
so what works in MS Works, fails after paying for excel2007. This doesn't
seem like an intentional limit, do you know if MS is aware of it or if there
is a way to open a bug report?



"
 
D

Dave Peterson

First, I don't think that MSWorks is free--it may have been bundled with your pc
when you purchased the pc, but I'm sure the price of the software was buried
into the price of the pc.

Second, I'm sure that MS is aware of the behavior.
 
W

Wayne

Yes, I am sure it was bundled in, but it is the low end product - Free was
excessive freedom of expression. The point being that the low end product
supported more than the high end one.
 
Top