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


Thank you Dave
"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