Results 1 to 2 of 2

Thread: Text not visible in cell only in Formula Bar (excel 2003)

  1. #1
    Join Date
    Jan 2006
    Posts
    192

    Text not visible in cell only in Formula Bar (excel 2003)

    I have opened my spreadsheet just now and checked that some text was missing. I clicked on the cell and found the text shows in the formula bar but not in cell. I then reformatted the cell and then changed font color to black, changed cell color but nothing worked. I then retyped info into cell and it showed until I left the cell than disappeard. I clicked again on cell and saw tect in the formula bar but it is not visible in cell? Can anyone please help.

  2. #2
    Join Date
    Nov 2005
    Posts
    2,483

    Re: Text not visible in cell only in Formula Bar (excel 2003)

    I am having the exact same issue in Excel 2003. It's happening in cells with text longer than 16 lines. Nothing beyond my 16th line will appear in the speadsheet regardless of how large I make the cell lengthwise or vertically. The text appears intact in the formula bar. Cuting and pasting the text into other cells or applications make no difference. When its pasted back into any cell in the spreadsheet those lines of text disappear.

Similar Threads

  1. How to display content of cell in a text box Excel 2003 VBA
    By !Jumala! in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 02:03 PM
  2. Want to paste data only in visible cell of Microsoft Excel
    By FullTimepass in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 07:21 PM
  3. Replies: 2
    Last Post: 03-02-2012, 07:28 PM
  4. Replies: 1
    Last Post: 25-01-2012, 06:27 PM
  5. How to change cell formula to text in VBA
    By Chhaya in forum Software Development
    Replies: 3
    Last Post: 08-05-2009, 12:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,306,952.82857 seconds with 18 queries