Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Summing merged cells (2000)

    I have several merged cells (merged across two columns) with numbers in, and when I attempt to create a sum (in another merged cell) Excel displays zero and I have to re-type all the values before the correct sum appears. Anyone come across this before? It's one of those things that, if you try to recreate it, it works perfectly!!

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

    Re: Summing merged cells (2000)

    The only thing I can think of would be that you got the "numbers" into the merged cells as text instead of numbers. If the merged cells were formatted as text when the numbers were entered, then they would have been entered as text. Changing the cell format to number would not change the already entered text values to numbers.
    Legare Coleman

Posting Permissions

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