View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Wayne Wayne is offline
external usenet poster
 
Posts: 133
Default I get # symbols in my cell instead of text

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?



"
"Dave Peterson" wrote:

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