PC Review


Reply
Thread Tools Rate Thread

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

 
 
Rahul
Guest
Posts: n/a
 
      29th Aug 2007
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


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      30th Aug 2007
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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:08 PM.