How to add cells with mix of 6 to 8 decimal places together

Question

Because of floating point values, I cannot add a string of cells that contain values such as:

 0.08178502
 0.09262585
 0.13261762
 0.13016377
 0.12302067
 0.1136332
 0.12176183
 0.11430552
 0.09971409
 0.125285

Even if I try adding the first two through a sum formula or auto sum through selecting them, excel spits out an error. I have googled this like crazy and tried to change number formats. Is there a function that can allow me to add this information ?

Screenshot:

The spreadsheet is available on my Dropbox.

Answer 1

Those numbers are all preceded by a NBSP (Char Code 160). So, in order to sum them, you have to remove that. Many solutions. Here's one:

=SUMPRODUCT(--SUBSTITUTE(A1:A18,CHAR(160),""))