Get #### when typing

B

Bill

When typing a lengthy statement in a cell I get ######. Is there a character
limitation in Excel 2007 and is there a work around to this?

Thank you

Bill
 
D

Dave Peterson

Try formatting the cell as General.

Excel has a display problem with strings between 255 and 1024 characters in
cells formatted as text.
 
×

מיכ×ל (מיקי) ×בידן

Try to make the cell/column wider and/or try to format it as "Wrapping text"
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top