Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Sacramento, California, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    # Error on text (2000/sr1)

    First, a late thankyou for the responses to my earlier problem with importing fixed-column files. I decided to change my input file to delimited by adding a column of '~' between the columns.

    Now that I've imported these files, I'm getting another error. The 3rd column of text displays the '#####' error, apparently when the character count goes over 255. The format is text with line-wrap on. No matter how big I make the cell, I get the display error. Is there any way to change this 255-byte limit?

  2. #2
    Lounger
    Join Date
    Nov 2001
    Location
    Sacramento, California, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: # Error on text (2000/sr1)

    Something else is going on: I'm finding some cells with way more than 255 bytes that display correctly. On the first cell I was testing, I reduced the byte count to 255 and got rid of the problem, hence my assumption.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: # Error on text (2000/sr1)

    Try Format, Cell, Number and apply General format (or anything other than Text !!)

    Andrew C

  4. #4
    Lounger
    Join Date
    Nov 2001
    Location
    Sacramento, California, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: # Error on text (2000/sr1)

    Thanks, that fixed it.

    When I was doing the import, the description of General on the import wizard seemed to indicate that it would do refomatting on the numbers and dates, so I chose Text.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •