Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Problem??? (2003)

    Attached is an example of a problem I've run into on a project. Why will column C average but D will not? Thanks for the help.
    Attached Files Attached Files

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

    Re: Formatting Problem??? (2003)

    Column D doesn't contain numbers, but text values that look like numbers. To correct this:
    - Select a blank cell.
    - Copy it (Ctrl+C)
    - Select D112.
    - Select Edit | Paste Special...
    - Click the Add option, then OK.

  3. #3
    Lounger
    Join Date
    Mar 2002
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Problem??? (2003)

    Thanks a million for the help. I don't know how I got it screwed-up in the first place. Thanks for the help on my protection question as well.

Posting Permissions

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