 |
 | 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 / New Users / October 2004### signs!
Hi, Sometimes I can fit a lot of text in a small font into a cell. Other times when I try to fit the same amount of text into another cell, all I end up with on the screen are # signs. Thanks for the help!! Hi this just indicates that the column width is not sufficient. Just extend the size of this column  Signature-- Regards Frank Kabel Frankfurt, Germany > Hi, > Sometimes I can fit a lot of text in a small font into a cell. Other > times when I try to fit the same amount of text into another cell, all I end > up with on the screen are # signs. Thanks for the help!! Format the cells for General: Select the cells Choose Format>Cells Select the Number tab Select the General category Click OK > Hi, > Sometimes I can fit a lot of text in a small font into a cell. Other > times when I try to fit the same amount of text into another cell, all I end > up with on the screen are # signs. Thanks for the help!! SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Your column needs to be widened if you get a ######## in your cell. To do this, go to Format Column Width and adjust your column width. Tara Wrote: > Hi, > Sometimes I can fit a lot of text in a small font into a cell. Other > times when I try to fit the same amount of text into another cell, all > I end > up with on the screen are # signs. Thanks for the help!! SignatureBenjieLop Tara If it is not a column width problem may be........ There seems to be a problem with text length between 256-1024 (0-255 and 1025+ work ok). The bad news is that this is the way Excel works. Re-formatting the cell(s) to General usually fixes the problem of the #######'s Gord Dibben Excel MVP >Hi, > Sometimes I can fit a lot of text in a small font into a cell. Other >times when I try to fit the same amount of text into another cell, all I end >up with on the screen are # signs. Thanks for the help!! If it is a column width issue, a shortcut to change the width is to move your mouse between the top of the problem column and the next column. Your mouse will change into two arrows pointing away from eachother and all you need to do is double-click. The column will automatically adjust to the width that it needs to be. Signatureintelgio |
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.