 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008# sign appearing in text boxes, Why?
When I have a large text box (10 lines of wrapped text) excel shows a series of # instead of the data. This only occurs when I am outside the cell, when inside the cell, the text displays correctly. When viewing in Print Preview, the # appear instead of the desired text. Why does excel do this (v2003) and how can I get it to stop? Thanks The # symbol indicates that the column is not wide enough to display the number within the cell. Widen the column to correct.  SignatureKevin Backmann > When I have a large text box (10 lines of wrapped text) excel shows a series > of # instead of the data. This only occurs when I am outside the cell, when [quoted text clipped - 4 lines] > > Thanks That workes, but takes me out of my page size settings. The next option worked great, thanks for the help > The # symbol indicates that the column is not wide enough to display the > number within the cell. Widen the column to correct. [quoted text clipped - 7 lines] > > > > Thanks It sounds like the text is not in a real textbox--just in a cell. If that's right, try formatting the cell as General (instead of text). If the text is long, you may find that it just "disappears" from the cell after about 1000 characters. You can see more by adding alt-enters (to force a new line within the cell) every 80-100 characters. > When I have a large text box (10 lines of wrapped text) excel shows a series > of # instead of the data. This only occurs when I am outside the cell, when [quoted text clipped - 4 lines] > > Thanks SignatureDave Peterson Thank you, Worked like a charm. > It sounds like the text is not in a real textbox--just in a cell. > [quoted text clipped - 12 lines] > > > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.