Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post
    My colleague has a spreadsheet that he has used for years. Now he must use it in Excel 2007, and he's getting very frustrated. For example—

    In cell G45, he wants to display the sum of the numbers in cells G18 thru G44. In cell G45, he types =SUM(G18:G44), then hits Enter. G45 now displays the formula he just typed, not what he'd expect. What's the fix?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts
    If only this cell exhibits the problem, first make certain the cell is not formatted as text - right click it, select Format Cells, Number formats, and apply the appropriate number format.
    -John ... I float in liquid gardens
    UTC -7±DS

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Caesar3 View Post
    My colleague has a spreadsheet that he has used for years. Now he must use it in Excel 2007, and he's getting very frustrated. For example—

    In cell G45, he wants to display the sum of the numbers in cells G18 thru G44. In cell G45, he types =SUM(G18:G44), then hits Enter. G45 now displays the formula he just typed, not what he'd expect. What's the fix?
    Two things to check before he gets too frustrated!.

    On the Office button select 'Excel Options' , Advanced, and scroll down to Display Options for this worksheet. Make sure that the "Show formulas in cells instead of calculated results is unticked.

    Secondly, before entering the formula in the cell, check what Format it is expecting (right click, Format Cells...). If it is Text, it will not calculate the results. Change the format to General and re-key the formula

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post
    Thank you! Thank you!

    It appears the offending cell was formatted as text. I haven't confirmed this (my colleague got called away in the meantime), but I'm betting that's the problem.

Posting Permissions

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