+ Reply to Thread
Results 1 to 3 of 3

Error displaying cells with a lot of data

  1. #1
    Registered User
    Join Date
    05-28-2005
    Location
    WI, USA
    MS-Off Ver
    Office XP/2003
    Posts
    95

    Error displaying cells with a lot of data

    Hi,

    I have a spreadsheet that I've populated with a macro. Several of these cells have multiple lines of information on them (separated by a linefeed character (char 10)). No matter what I do to the cell itself, it will always display as a series of number signs (#####). I've expanded the cell to the maximum size (409x255) and it still will not display correctly... Even when I select "Shrink to fit," I still can't see the data. Any thoughts?

    Thanks,
    Chris
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    11-20-2007
    Location
    Felixstowe, England
    MS-Off Ver
    Excel 2013, 2019
    Posts
    217

    Post workbook

    Can you post the workbook, and a sample of this happening, rather than just a picture of what you are seeing?

  3. #3
    Registered User
    Join Date
    05-28-2005
    Location
    WI, USA
    MS-Off Ver
    Office XP/2003
    Posts
    95
    I was able to figure it out. I had set the format to text, but when I set it back to General, it worked fine. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1