Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Text error

I do not want to expand the cell as my comments are quiet long.
They appear just fine in some cells but not in others.
All the text is there and can be read but if I format the cell from general
to text that's when it changes it to ####.
--
A.


"PCLIVE" wrote:

At the top of your sheet, double-click between the two columns with the
column that has the #### on the left. For example, if cell C5 is displaying
####, then double-click on the line between C and D at the top of your
sheet. This should automatically widen the column as necessary in order to
display the full contents.


"Andmor" wrote in message
...
I am entering comments on student performance.

The other cells that i have filled in are quite long and have the text
appear just fine without making the colums bigger.
--
A.


"John" wrote:

Have you tried to make the column wider?

What text are you entering?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Andmor" wrote:

I have been entering text into cells formatted for text.
That is until I have reached some cells that are formatted for text but
the
text comes out ####. Any suggestions?
I even tried to apply the formatting from a cell where the text appears
correctly but have had no success.
--
A.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number Stored as text Error Torero Excel Worksheet Functions 2 December 1st 06 01:28 PM
Counting instances of found text (Excel error? Or user error?) S Davis Excel Worksheet Functions 5 September 12th 06 04:52 PM
Text Error Message Mike Excel Worksheet Functions 1 February 21st 06 05:07 PM
How to change and error message to text NEWB Excel Worksheet Functions 4 December 1st 05 09:21 PM
Text and the #VALUE error Harry Garrett Excel Worksheet Functions 2 March 10th 05 06:24 PM


All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"