Its not working. Issues in the sum totalThese are all texts. You will notice green marker to top left of each cell. When you hover, it will indicate number stored as text.
Just select entire range with that marker and convert to number.
Yes this works, but I was in search of something better than thisI'm on Excel 2010 and I don't get the green markers, however, if I select all the numbers and Find & Replace (Ctrl+H) $ with nothing, all the texts are converted to numbers.
What kind of thing were you looking for?Yes this works, but I was in search of something better than this
I can not see the green marker, I have office 2016Demonstrate how it isn't working. Simply stating something doesn't work won't get you any better help.
FYI - I tested my solution and worked fine on my end.
If you want to you can use formula to convert text to number, but I don't recommend it.
Ex: =SUM(VALUE(C2:C11)) Confirmed as array (CSE).
Or =SUMPRODUCT(VALUE(C2:C11))