I copied two sets of numbers based on two different queries from the same
source into a spreadhseet. The first set of numbers I copied into the
spreadsheet will sum up fine. The second set of numbers will not sum. I
tried reformatting the cells as number with 2 decimal places and then when I
highlight the cells the bottom right tally shows a count not a sum as I'd
expect. There are no $ signs, no commas, etc. and I have already tried
reformatting the cells in various different number formats (number with 2
decimals, currency, etc.) and that doesn't help. If I manually type over the
figure in the cell it will then be included in the sum total (without
changing any formatting). This is a very large spreadsheet and it is not
practical to retype everything. Is there a way to reformat the cells which
I've not tried that might work? Any other suggestions to get them to total
up?

Thanks in advance for any help you can render.