Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Why not summ? (2000 sr 1)

    in I1 and J1 why?

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

    Re: Why not summ? (2000 sr 1)

    Because the values in column I and J are text.
    - Select I3:J17000
    - Select Format | Cells...
    - Activate the Number tab.
    - Select the Number category.
    - Activate the Alignment tab.
    - Set Horizontal alignment to General.
    - Click OK.
    You will see that the values are now left-aligned; this is because they are still text values. To repair this:
    - Select an empty cell.
    - Copy it to the clipboard (Ctrl+C)
    - Select I3:J17000
    - Select Edit | Paste Special...
    - Click the Add option.
    - Click OK.

Posting Permissions

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