Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Formatting Cells to extend beyond 255 character limit

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can someone change the format of a cell so that it will hold more than 255 characters?

  2. #2
    Guest

    Default

    Let me know when you get the answer. I need to know that as well please. If you could email me the answer at keverton@ecs-inc.com I would greatly appreciate it.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Soozie
    I don't think you can do this on a permanent basis but it would appear you can work with more than 255 characters in a cell. Sometimes when I go to copy a sheet a message tells me that some cells contain more than 255 characters which will be lost unless you actually copy those cells and paste to the new sheet. They will probably be truncated to 255 characters when you go to save.
    regards
    Derek

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 06:22, Soozie wrote:
    How can someone change the format of a cell so that it will hold more than 255 characters?
    Formatting doesn't alter the contents of a worksheet cell. Furthermore, a cell can contain 32,000 characters.

    [ This Message was edited by: Mark W. on 2002-03-08 07:44 ]

  5. #5
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


  6. #6
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good question. I think what Suzie meant is that when you wrap text in a cell, it will only show up to 255 characters. You can enter more characters than that but it shows as "XXXXXXXXXXXX".

    If anyone has a work-around to this, I would also greatly appreciate knowing what it is.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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