Cell displays ################# instead of the text

's Computer Specifications

Hi,

I have run into an issue that when the text in the cell is greater than a
certain number of characters, it is displayed as "#####################". If
I change the cell type to "General" instead of "Text" then it displays fine.
How can I fix this so that the type can be "Text" and still display
properly.

Thanks
Rahul

's Computer Specifications

Check your other post.

Rahul wrote:
>
> Hi,
>
> I have run into an issue that when the text in the cell is greater than a
> certain number of characters, it is displayed as "#####################". If
> I change the cell type to "General" instead of "Text" then it displays fine.
> How can I fix this so that the type can be "Text" and still display
> properly.
>
> Thanks
> Rahul

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell displays Formula text	=?Utf-8?B?aW50ZWxsYnVz?=	Microsoft Excel Misc	1	27th Sep 2007 11:56 PM
Cell displays ################# instead of the text	Rahul	Microsoft Excel Discussion	11	31st Aug 2007 07:45 PM
RE: Can I align text in a cell so it displays just below the cell?	=?Utf-8?B?SmFpbWU=?=	Microsoft Excel Misc	0	23rd Dec 2006 12:05 AM
Text displays as ### in a cell.	=?Utf-8?B?QW5kcmU=?=	Microsoft Excel Worksheet Functions	1	2nd Nov 2005 03:27 PM
Formula displays as text in one cell	=?Utf-8?B?QmFpbmVz?=	Microsoft Excel Misc	3	18th Feb 2004 06:11 PM