Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Oct 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XLXP: Numbered List not showing? (XP)

    Hi,

    As per the attached screen-shot, with ExcelXP, I entered the numbered list with ALT+CR for each line.
    For some reason, it just appears as a list of hashes.

    I don't mind if the text wraps.
    How can I solve this problem?

    TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XLXP: Numbered List not showing? (XP)

    Try again in another cell or in another workbook, and start with a small list. What happens then?

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLXP: Numbered List not showing? (XP)

    Select the cell. Select Cells from the Format Menu. Click on the Alignment tab. In the Text Control section put a check next to "Wrap text".
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Oct 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLXP: Numbered List not showing? (XP)

    I tried in another cell (copy,paste) and same problem.
    Also if I paste content into another workbook, same problem.

    If I type a smaller list, it seems Ok for a while, then after 9/10 points goes AWOL. I am using ALT+Enter to input each point.

    The Word Wrap for that cell is already ticked.

    Help!!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XLXP: Numbered List not showing? (XP)

    Can you post a workbook with a single worksheet and a single populated cell that demonstrates the problem? In a test, I could create a list with over 30 entries (in fact, over 200 entries, but the row height didn't expand beyond 39 entries.)

  6. #6
    2 Star Lounger
    Join Date
    Oct 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLXP: Numbered List not showing? (XP)

    Cheers.

    I have attached the trouble file itself replacing actual content.
    The trouble cell is the big one with the row of hashes.

    Thanks.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XLXP: Numbered List not showing? (XP)

    Select the cell.
    Select Format | Number...
    Select General.
    Click OK.

    (The cell is merged; the first cell is set to Text format; apparently this prevents the contents from being displayed correctly.)

  8. #8
    2 Star Lounger
    Join Date
    Oct 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLXP: Numbered List not showing? (XP)

    Thanks Hans.

    Appreciate it.

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: XLXP: Numbered List not showing? (XP)

    When Text format is chosen, the number of characters must be <256 or you will get the string of "#s.

    I assume it has something to do with the column width limitation of 255 characters. You always get this wiht an invalid "display" formatting or too narrow of a column.

    Steve

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: XLXP: Numbered List not showing? (XP)

    Thanks for clearing that up. I did notice that the contents were displayed correctly if the cell contained less than 256 characters, but forgot to explore it further.

Posting Permissions

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