A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

### signs!



 
 
Thread Tools Display Modes
  #1  
Old October 15th, 2004, 05:13 PM
Tara
external usenet poster
 
Posts: n/a
Default ### 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!!
  #2  
Old October 15th, 2004, 05:19 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default

Hi
this just indicates that the column width is not sufficient. Just
extend the size of this column

--
Regards
Frank Kabel
Frankfurt, Germany

"Tara" schrieb im Newsbeitrag
...
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!!


  #3  
Old October 15th, 2004, 05:26 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

Format the cells for General:

Select the cells
Choose FormatCells
Select the Number tab
Select the General category
Click OK

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!!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #4  
Old October 15th, 2004, 05:27 PM
BenjieLop
external usenet poster
 
Posts: n/a
Default


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!!



--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=269622

  #5  
Old October 15th, 2004, 09:55 PM
Gord Dibben
external usenet poster
 
Posts: n/a
Default

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

On Fri, 15 Oct 2004 09:13:01 -0700, "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!!


  #6  
Old October 16th, 2004, 04:56 AM
intelgio
external usenet poster
 
Posts: n/a
Default


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.


--
intelgio


------------------------------------------------------------------------
intelgio's Profile: http://www.excelforum.com/member.php...o&userid=15356
View this thread: http://www.excelforum.com/showthread...hreadid=269622

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How would you show all the cells added with plus signs? Eldraad General Discussion 15 August 16th, 2004 05:52 AM
Comparison of Signs Diane Running & Setting Up Queries 7 July 30th, 2004 10:48 PM
Unwanted number signs JulieD Worksheet Functions 5 March 30th, 2004 04:49 AM


All times are GMT +1. The time now is 10:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.